Need to break out a matrix outline data set from its alphabetical sort

[JediMole]

While I need this report in the 'Visual' Outline layout, the column data set needs to be sorted in a different way.  Is there a way to transform the column into a 'table', then set the columns in the order I want?  See picture attached for what I have so far

[Ritaf1983 · Accepted solution]

Hi @JediMole 
The engine automatically sorts matrix columns alphabetically.
To sort them differently, you need to add a numeric column and set it as the sort order.
Example shown in the images below.

Result:

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[JediMole]

YAY, it took me a bit to navigate the sort order and such, but I did the first two and its working.  I'll add the rest later to round it out!! TY so much

[Ritaf1983]

Glad to help 🙂

[lbendlin]

Add a sort column to your dimension table. then "Sort a column by another column".