Matrix visual sorting

[Maha16]

Imported data from SharePoint excel to power bi. Used matrix visual to show the same data as of excel. Excel is having columns like managers name,  parameters name, value. None of these are unique columns. And in matrix visual showing in alphabetical order. But want to show it in same order as excel. So tried creating new index column , and sorting based on index column to parameters. But can't apply sorting to the columns, since column is having duplicate values. So is there any solution for this when we don't hav any unique values of columns , how we can show the data in matrix visual as the same order in excel

[Idrissshatila · Accepted solution]

Hello @Maha16 ,

the only solution is to add the index column in the matrix and sort using it.

incase you don't want to show it, then color it as the background and still use it to sort.

kindly support my youtube channel https://www.youtube.com/@PowerBISolution