Sort Column Header in Matrix Table

[Anonymous]

I am new to Power BI and I am having trouble getting the columns in a matrix in the correct order.  I have set up a linked helper table that includes a sort order column sorted the table by that column but it is not sorting the columns as I need.  I need the 0-6 MO ago column at the far right - the order needs to be simply reversed.

Also, I would like to eliminate the Totals Column.  How can I do this?

Here is the pbix file: https://drive.google.com/open?id=1NB6Lw4JGwVgrKQtdfYq14VG1qSZv8J6_

Thank you for your help!

 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

To eliminate the Totals Column, turn off these options.

To sort with correct order

Click on "TimeFrame2" column, then select "Modeling"->"Sort by column"->"TimeFrame2SortOrder"

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cmcmahan]

In order to remove the totals column, go to the formatting tab, and go to Subtotals > Column subtotals > Off.

In order to change the order of columns, we get more complicated.  You need to create another column on the data table to order by, and set the column to be sorted in question to sort by the new index column.

More info can be found here: https://stackoverflow.com/questions/49685042/powerbi-sort-columns-in-matrix-visual