Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi， Anonymous 

Try to create a Rank column as below:

Rank = RANKX('Table','Table'[Age],,DESC,Dense)

To avoid  "A circular dependency......",please create another column 'Age2'

Age 2 = 'Table'[Age]

 Then sort column ‘Age2’ by column "Rank":

The result will show as below:

 

Please check attached pbix file for more details.

 

Best Regards,
Community Support Team _ Eason