Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How can I set the column order on a matrix. See screen shot below. I want the columns ordered as follows:
1. No Test Cases
2. Missing Test Runs
3. Not Passed
4 Passed
5 Closed
Solved! Go to Solution.
Hi,
you'll need to create a new table with the sorting order for you columns and then use sort by in the column tools to adjust it to that order. I wrote a blog which includes how to do this, check out: https://github.com/DOLEARY85/Power-BI-Replicate-Excel-Table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
I don't see a column tools menu item in Power BI desktop
You have to select the column you want sorted first in data pane on the right side of the screen for it to appear.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
you'll need to create a new table with the sorting order for you columns and then use sort by in the column tools to adjust it to that order. I wrote a blog which includes how to do this, check out: https://github.com/DOLEARY85/Power-BI-Replicate-Excel-Table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |