Sorting Matrix Table Values

[dpell3]

Hi everyone, I'm trying to sort the following values to arrange the matrix with the SWITCH function to avail:

Sort = SWITCH('Merged Data'[Action], "Market", 1, "Region", 2, "National", 3, "Received", 4)

I'm trying to get the table to look like this:

Market

- No BOM Order Found

- BOM in Draft

- Pending Market Review

- Review Shortage

Region

- Pending Regional Review

- ...

- ...

- ...

National

- ...

Received

- ...

Anyone aware of a simpler way to sort rows/columns?

Many thanks!

[edhans · Accepted solution]

You would need to create one of two things:

• Child tables that had your main headings (Market, Region, etc) with a second field with 1, 2, 3, 4, etc in them. Then select your main heading, Modeling tab, sort by column, and pick the second field.
  • repeat for the sub heading (BOM in draft, No BOM order found), etc.
• or add a column to the main table that has Market, Region ,etc. but for Market, 1 (your sort code) would have to repeat for every occurance of Market, 2 to repeat for region ,etc. 

See this article for a more detailed overview of how to sort by another column rather than just alphabetically.