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
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!
Solved! Go to Solution.
Hi @BFid
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.
Hi @BFid
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.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |