Forum Discussion
Sort Matrix by any other column than total column
Dear PowerBi Community, I created a Matrix comparing sales of three years and would like to sort it descending by last year's sales. PowerBi however provides the option to sort by the total colu...
I think I found a workaround.
I have created three additional columns named 2020, 2021 and 2022.
In each column I inserted an IF function:
e.g. Sales 2020 = IF('Year'="2020",'Sales',0)
This is seems to be very bad practice however it works.
If you have any other ideas how to fix it more professional kindly let me know.
Best
Dennis