Forum Discussion
How to sort matrix columns descending?
I have a matrix with a text field as the Row field, and an integer as the Column field. The columns display in ascending order. I want the columns to show in descending order. There does not seem to ...
You'll have to make your sort column in the query editor to avoid the circular dependency error. [Age]* -1 like you did before but in query.
Regards,
Pat
MattAllington
Community Champion
Community ChampionI assume you mean the columns of data. This is not possible because it is a table of data, not a set of 18 independent columns. Each has their own sort order
MattAllington, SSRS does this just fine. In the Column Group settings you can select which data field should be used to sort the Column Headers in the matric visual.
I want to know how to achieve the same in Power BI.