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
Anonymous , You need to create sort columns for both of them and marks as sort column
example 1
Row heading 1-1 [Row Heading 1]
Row heading 1 sort = Switch([Row heading 1],
"BBB",1,
"CCC",2,
3)
You can mark Row heading 1 sort as a sort column for Row heading 1 or Row heading 1 _1 and use is visual Additional column suggested to avoid circular dependency
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Yes, It helped. Thanks a lot