Forum Discussion
Matrix order with Date hierarchy
Hi larx_mandel ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a sort order table
2. Sort the field [Month] of sort order table by the column [Sort Order]
3. Create the relationship between the sort order table and data table base on the field [Month]
4. Create a table visaul just as shown in the below screenshot
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Sort a Column with a Custom Order in Power BI - RADACAD
Best Regards
I tried with Shift key but it is not working. It is ordering separately.
My Power BI version is Version: 2.139.1678.0 64-bit (january 2025).
Thanks.
Hi larx_mandel ,
Please download the latest version of Power BI Desktop and check if you can order multiple fields simultaneously.
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Best Regards
With new version I have the same behavior. Any other solution to this problem? Thanks.
Hi larx_mandel ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a sort order table
2. Sort the field [Month] of sort order table by the column [Sort Order]
3. Create the relationship between the sort order table and data table base on the field [Month]
4. Create a table visaul just as shown in the below screenshot
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Sort a Column with a Custom Order in Power BI - RADACAD
Best Regards