Forum Discussion
Helper IVColumn Order on Matrix
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
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 👍
3 Replies
- DOLEARY85
Resident Rockstar
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 👍
TomSinAAI don't see a column tools menu item in Power BI desktop
- DOLEARY85
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 👍