Forum Discussion
Solved
Changing sort order per category
Hey guys, Lets say I have a table with 4 columns: Attribute, Category and Order and Percent. The order is different per category. In a column chart I have atributes in the x and percent ...
Hi AlmantasPBIguy ,
Since the attribute is the same and the order differs you cannot make a sort by column one option can be to create a new column that uses a empty character something similar to this:
'Table'[Attribute]<u+200f><uNew Column = REPT("<u+200f><u+200f><u+200e> <u+200e>", 'Table'[Order]) &olumn = REPT("<u+200f><u 'Table'[Attribute]<u+200f><u+200f><u+200e> <u+nbsp;e'[Attribute]<u+200f><u
nbsp;e'[Attribute]<u+200f><uIn the table it will look separated but when you used it on the visualizations the character will dissapear:
Hi AlmantasPBIguy ,
Since the attribute is the same and the order differs you cannot make a sort by column one option can be to create a new column that uses a empty character something similar to this:
New Column = REPT("<u+200f><u+200f><u+200e> <u+200e>", 'Table'[Order]) &olumn = REPT("<u+200f><u 'Table'[Attribute]<u+200f><u+200f><u+200e> <u+nbsp;e'[Attribute]<u+200f><u
nbsp;e'[Attribute]<u+200f><u
In the table it will look separated but when you used it on the visualizations the character will dissapear:
Worked like a charm, thanks!