Forum Discussion
Reorder columns for Matrix visualization (with sort order data provided from the same table)
Please see this page for how to do this using the Sort By Column feature in Power BI.
Sort by column in Power BI Desktop - Power BI | Microsoft Docs
Pat
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.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.
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.
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.
I tried this, but the columns are still not sorting horizontally.
Hello - I tried this and received the following error message. To get the order# in a new column I used a SWITCH formula. How can I fix this?
This view does not exist in the latest versions of PowerBI Desktop; the Column Tools menu is only found in the Table View, not the Report view
