Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to sort my column headers (“no goal level”, “platinum”) alphabetically, but I don’t see a way to do this. I can only sort by “vertical” columns, by agency name and the employee count. What I want is the columns to appear "Gold, Gold Plus, No goal level, Platinum, Silver".
The “sort by column” is grayed out because I am connected to live data. Also, there is no option for this type of sorting on the menu, as can be seen in my screenshot.
How can I get this done?
Try setting up a "sort order" column or table and sort the current level alphabetically. Gold = 1, Gold Plus = 2, etc
Looks like this is in a matrix. Have you tried manually ordering them in alphabetical order in the column input area?
Hi Clay, yes it's a matrix, I should have mentioned that.
There is no choice for ordering there. It's only the "current level". Any other ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |