Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MarshalSK
Resolver I
Resolver I

How to get Bar chart with sorting

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

MarshalSK_0-1707407709788.png

 

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

HI @MarshalSK 

You are looking for Sub Category wise sort within each category
Please create a lookup table with the below format

SubCategory SortBy
A1
B2
C3
D4

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

View solution in original post

5 REPLIES 5
PijushRoy
Super User
Super User

HI @MarshalSK 

You are looking for Sub Category wise sort within each category
Please create a lookup table with the below format

SubCategory SortBy
A1
B2
C3
D4

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
Super User
Super User

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

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

PijushRoy_0-1707413947172.png

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

In each category, sorting should take place. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.