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
mahoneypat
Microsoft Employee
Microsoft EmployeeYou'll need to make a Sort By Column for the column used in the Matrix columns. Please see this article.
Quick Tips: How to Sort Matrix by Column in Descending Order (biinsight.com)
Regards,
Pat
mahoneypat In the Data tab, I have done this:
created a new calculated column called NegAge as = -[Age]
tried to set the Sort By Columns on the Age Column to be NegAge. But this results in an error "A circular dependency was detected"
Instead, I tried setting the [Age] Column sort option to "Sort descending". But none of that changes the [Age] columns in the matrix from displaying in ascending order.