Forum Discussion
Sorting values in certain order -Matrix Visual
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create sort order dimension tables as below screenshot using Enter Data method
2. Create the relationships between dimension tables and fact table
3. Apply the fields in the dimension tables onto the matrix and sort ROWHEADING1 and ROWHEADING2 by column: Sort order
In addition, you can refer the following links to get it.
Sort one column by another column in Power BI
Sort a Column with a Custom Order in Power BI
Power BI - Custom Sorting in 3 Easy Steps!
If the above one can't help you get the desired result, please provide some sample data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
How to upload PBI in Community
Best Regards
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create sort order dimension tables as below screenshot using Enter Data method
2. Create the relationships between dimension tables and fact table
3. Apply the fields in the dimension tables onto the matrix and sort ROWHEADING1 and ROWHEADING2 by column: Sort order
In addition, you can refer the following links to get it.
Sort one column by another column in Power BI
Sort a Column with a Custom Order in Power BI
Power BI - Custom Sorting in 3 Easy Steps!
If the above one can't help you get the desired result, please provide some sample data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
How to upload PBI in Community
Best Regards
Thanks for the reply. It works