Forum Discussion

TomSinAA's avatar
TomSinAA
Helper IV
3 years ago
Solved

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    
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

TomSinAA's avatar
TomSinAA
Helper IV
3 years ago

I don't see a column tools menu item in Power BI desktop

 

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    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 👍