Andreas Simon on 22 Nov 2022 06:31:52
When sorting a column by another column (for example sort month name by month number) this sorting is applied in tables, slicers etc. Perfect!
But it is not applied in visual legends (for example pie-chart). But legends should be sorted by the other column, too (in the example, when month names are shown they should be sorted by month number - in case sorting by name is chosen).
Unfortunately I can't add screenshots, so I need to describe it:
I was using time ranges and like:
0-5 months
6-12 months
1-2 years
>2 years
Adding a sort column in tables, slicer the sorting is as above.
But using a pie chart the legend sorting is like:
>2 years
0-5 months
1-2 years
6-12 months