PowerBI Sort Columns in Matrix Visual

Question

I have a Matrix visual in Microsoft PowerBI with Australian 'States' as rows and 'Months Ago' as columns.

By default the Matrix shows my columns from 0 months ago to 12. I would like it to show from 12 months ago on the left to 0 months ago on the right.

+-------------------+-----------------------------+-------+
|                   | Months Ago                  |       |
+-------------------+-----------------------------+-------+
| State             | 0  | 1  | 2  | 3  | 4  | 5  | Total |
+-------------------+----+----+----+----+----+----+-------+
| Queensland        | 10 | 10 | 10 | 10 | 10 | 10 | 60    |
+-------------------+----+----+----+----+----+----+-------+
| New South Wales   |    |    |    |    |    |    |       |
+-------------------+----+----+----+----+----+----+-------+
| Victoria          |    |    |    |    |    |    |       |
+-------------------+----+----+----+----+----+----+-------+
| South Australia   |    |    |    |    |    |    |       |
+-------------------+----+----+----+----+----+----+-------+
| Western Australia |    |    |    |    |    |    |       |
+-------------------+----+----+----+----+----+----+-------+

Currently I am only given the option to sort by the value type fields (ie revenue etc).

Is there any option to sort/order the Column Headers?

Foxan Ng Foxan Ng · Accepted Answer · 2018-04-06T07:06:50

I don't think there is an option for you to sort column headers directly.

However, you can change the default sort order for the Months Ago column so that it will be reflected in general.

You can add a custom column MonthSrt = 12 - [Months Ago] in query editor:

(It won't work in DAX because of a known issue)

Then you can select the Months Ago column and sort it by MonthSrt:

The custom sort will be applied when you use the Months Ago column in visuals:

PowerBI Sort Columns in Matrix Visual

3 Answers