Sort bar chart stacked

[Jsobrinho77]

Hi guys,

I have dimensions, years, and Categories to split the bar. I have a measure as: if( Year = 2022, sum(value), sum(value2)) the values are correct, the problem is in sort. Is not sorted by Years different from 2022 (value2), is always considered to sort by sum(value).

Its possible to sort each dimension Year, by IF measure?  if( Year = 2022, sum(value), sum(value2))