topic Re: Sort Matrix by any other column than total column in DAX Commands and Tips

Sort Matrix by any other column than total column

dennisbraun — Wed, 25 Oct 2023 15:27:43 GMT

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 column of all three years combined.

Is there a workaround existing to sort by any other column than the total?

In Excel Pivot Tables one can easily sort by each possible column.

Best

Dennis

Re: Sort Matrix by any other column than total column

Walter_W2022 — Thu, 26 Oct 2023 09:26:27 GMT

Hi dennisbraun , could you please make up some data for your case? and create a draft by using PBI workbook, then upload to here for us to analyse? it will be much easier to analyse and find solution, thanks.

Re: Sort Matrix by any other column than total column

dennisbraun — Fri, 27 Oct 2023 12:16:03 GMT

Dear Walter_W2022 thank you for your proposal!
I will share a link with the dummy .pbix as I am not in a position to add attachments:
https://files.fileexchange.aesculap.extranet.bbraun.com/thirtydays/dddde7b4-d4f6-464f-98af-32cd5d0a4368/Example.pbix
If the link should not work kindly point out to me and I will try to insert a new one.

Re: Sort Matrix by any other column than total column

dennisbraun — Fri, 27 Oct 2023 12:20:51 GMT

The difference to a standard report would be that the years are listed in the rows instead of being already separated by column.

Re: Sort Matrix by any other column than total column

dennisbraun — Fri, 27 Oct 2023 12:58:00 GMT

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