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

[GOLEARY735]

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. 

Any help is greatly appreciated!

Thanks, 

Grace

[danextian · Accepted solution]

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.

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.

[GOLEARY735]

Hi @danextian, 

Sorted - thank you very much. 
Grace