Forum Discussion
Column 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
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 👍
