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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.