cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting in Matrix visual

Hi,

 

I have a matrix visual, where i have different KPI's as columns, and different dimensions as rows. both can be dynamically changed.

 

There are 3 levels of column headers under which the KPI's are displayed; can we have sorting on these column headers? if yes, how?

 

 

  Column option1
  Option 1Option 2
  KPI1KPI2KPI3KPI4
Row 114833
Row 225444
Row 336366

 

 

 

Thanks,

Swaroop 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @SwaroopRoyM,

 

Do you mean you would like to display KPI values (KPI1 KPI2 KPI3 KPI4) in different order? 

 

You can try create a new table to define the sort order via Sort by Column feature: 

 

q3.PNGq4.PNG

 

 

You can download the pbix file to have a look. 

 

Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...

 

 

Best Regards,
Qiuyun Yu