Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
BFid
Regular Visitor

Sort Column Header in Matrix Table

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.

 

Matrix Column Header Sort

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!

 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @BFid 

To eliminate the Totals Column, turn off these options.

6.png

To sort with correct order

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

7.png

 

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.

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @BFid 

To eliminate the Totals Column, turn off these options.

6.png

To sort with correct order

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

7.png

 

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
Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!