Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |