Quick Tips: How to Sort Matrix by Column in Descending Order

Last week Microsoft released Power BI Desktop March 2020 which I was hoping that it includes a simple feature on Matrix visual to be able to sort the Martix by column in descending order, but, it doesn’t. So, in this post I quickly show you how to sort Matrix by column in descending order.

Here is the scenario. One of my customers is building a report in Power BI showing sales by Year, Month and Day of Week in a Matrix as below.

Everything looks fine! But looking at the Matrix sorting quickly reveals that such feature is NOT available (YET). But the customer would like to see the Matrix sorted by Year in descending order, something like this.

Here is the solution which is super simple.

• Add a new “Year” column, either in Power Query or using DAX. I use DAX just to keep it as simple as possible

MatrixSortDescYear = 'Date'[Year]

Read the rest in my website: https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/

?Looking for a handy Power BI documentation tool? Try Power BI Documenter.