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
HI MarshalSK
You are looking for Sub Category wise sort within each category
Please create a lookup table with the below format
| SubCategory | 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/2203163
Almost the same steps as screenshot mentioned in this solution