Move Column Headings In Matrix - Power Bi Desktop

[IainPowerBI]

Hi,

I am really struggling to move my headings in the matrix below.  As you can see this needs to be sorted in the correct format but I am unable to find a way to do this.  Any help would be greatly appreciated.

[TheoC]

Hi @IainPowerBI 

Did you create your "groups" in Power Query, Calculated Columns or via the Group tool?

The end result you need is to create a rank for each of the group's you have created.   Below is a Calculated Column you can use for this. Just add the Group Names, followed by the rank order (i.e. 1, 2, 3, 4, 5.... ) and on the last one, ensure you end it with " , 0 ) "

Rank = 

SWITCH (
     TRUE () , 
          'Table'[Group] = "0" , 1 ,
          'Table'[Group] = "1" , 2 ,
          'Table'[Group] = "2" , 3 ,
          'Table'[Group = "3-5" , 4 ,
          'Table'[Group = .... ,
          0
       )

Once you do this, you can then click on your Group button in the Field pane and go to the Sort By Column button in the ribbon.  Sort by the new Rank column, and you're done 🙂

All the best!

Theo