Forum Discussion
How to get Bar chart with sorting
HI MarshalSK
You are looking for Sub Category wise sort within each category
Please create a lookup table with the below formatSubCategory SortBy A 1 B 2 C 3 D 4 Click on Sub Category column and change Sort to SortBy Column
Now Create a relationship with the main table and with SubCategory column
Use SubCategory from the lookup table
https://community.fabric.microsoft.com/t5/Desktop/Custom-sort-on-rows-and-columns-in-Power-BI-Matrix/td-p/2203163Almost the same steps as screenshot mentioned in this solution
That's is a sample screen shot from another tool. In PBI, I am not sure how to accomplish this.
Hi MarshalSK
Find the steps
Custom sort - find the steps
https://community.fabric.microsoft.com/t5/Desktop/Custom-sort-on-rows-and-columns-in-Power-BI-Matrix/td-p/2203163
Iff your requirement is solved, please make THIS ANSWER as SOLUTION
In each category, sorting should take place.