Sorting in Matrix visual

[SwaroopRoyM]

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 1	Option 2
		KPI1	KPI2	KPI3	KPI4
Row 1	1	4	8	33
Row 2	2	5	4	44
Row 3	3	6	3	66

Thanks,

Swaroop 

[v-qiuyu-msft]

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: 

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