Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
5 years ago
Solved

Reorder columns for Matrix visualization (with sort order data provided from the same table)

I am trying to reorder the column order for a Matrix visualization. So, I am trying to have "Medicare A" (ReportColumnOrder = 1) as displayed far left, then after "Medicate HMO" (ReportColumnOrder ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi JustinDoh1 ,

    Select the [PayerNameDefined] column, use 'Sort by column' feature in Columns tools and sort the column by the [ReportColumnOrder] column, you will get the result.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JustinDoh1's avatar
    JustinDoh1
    5 years ago

    v-yingjl Thank you. I was thinking in a harder way. When I searched thru Google, there were so many other solutions related to similar cases, so I thought I have to solve in Power Query (M language).  Also, there was some error on SQL side, so I had to fix it.

HappyFabric's avatar
HappyFabric
Microsoft Employee
1 year ago

For Matrix I could only get it to work if I created a new column in my data table. I could not create a Measure to define the new sorting column.