Column Order on Matrix

[TomSinAA]

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

[TomSinAA]

I 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 👍

[DOLEARY85 · Accepted 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 👍