How to get Bar chart with sorting

[MarshalSK]

Hi Folks, How to achieve below chart along with Category wise sorting ?

[PijushRoy · Accepted 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...

Almost the same steps as screenshot mentioned in this solution

[PijushRoy]

Hi @MarshalSK 

The image you shared is already sorted by Category in ASC order. You can update the sort order by clicking 3 dots top right side matrix table.
If you are looking for custom sort, please find the steps
https://community.fabric.microsoft.com/t5/Desktop/Custom-sort-on-rows-and-columns-in-Power-BI-Matrix...

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[MarshalSK]

That's is a sample screen shot from another tool. In PBI, I am not sure how to accomplish this. 

[PijushRoy]

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...

Iff your requirement is solved, please make THIS ANSWER as SOLUTION

[MarshalSK]

In each category, sorting should take place.