Forum Discussion
Solved
Sorting a matrix with multiple measures in row groups
Hi all, I don't know if this is possible but I am trying to find a way to row a matrix that currently only consists of 6 measures added to the Values part of a Matrix. There are no rows or columns ad...
Hi, benlynch225 ;
You could enter a table such as:
then create a measure.
Measure = SWITCH(MAX('Table (2)'[Name]), "Current Plan",[Current Plan], "Last 2 Weeks Actuals",[Last 2 Weeks Actuals], "What If Scenario",[What If Scenario], "Prev Year Actuals",[Prev Year Actuals])the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You should be able to sort this by the same order that you put the measures into the Values well.