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
GOLEARY735
New Member

Sort by values that are shown as a percentage in a Matrix table.

Good morning. 

 

I'm new to Power BI and I have been searching for a solution to a sorting problem within a Matrix table. 

I have a list of suppliers in the rows section and my columns are 'Supplier OTIF Group' which is an additional column I added in the query editor based on a delivery date. Named 'Late' and 'On time'. The values are shown as a percentage, and what I'm trying to do is sort the 'Late' column in accending order to show the worst performing suppliers first, but I can't find a way to do this. 

 

GOLEARY735_0-1716714661879.png

 

Any help is greatly appreciated!

 

Thanks, 

Grace

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @GOLEARY735 

I assuming  Late and On Time are categories and not measures. The Column header cannot be sorted by its categories but by the measures in Values tile. Please see screenshot below.

danextian_0-1716726399377.png

If you want the rows to be sorted by Late, create a separate measure for Late and On Time and and use those measures instead.

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

2 REPLIES 2
danextian
Super User
Super User

Hi @GOLEARY735 

I assuming  Late and On Time are categories and not measures. The Column header cannot be sorted by its categories but by the measures in Values tile. Please see screenshot below.

danextian_0-1716726399377.png

If you want the rows to be sorted by Late, create a separate measure for Late and On Time and and use those measures instead.

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @danextian

Sorted - thank you very much. 
Grace

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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