Forum Discussion
Power BI Desktop
Hi,
Hope you all are doing well!
I am trying to create a report using Matrix visualization. By default the columns are taking in an alphabetical order as shown in table 1. But I want my report to be as shown in table 2. Can anybody help me on this?
Table 1:
| Groups | A | B | C | D | E |
| 1 | x | x | x | x | x |
| 2 | x | x | x | x | x |
| 3 | x | x | x | x | x |
| 4 | x | x | x | x | x |
| 5 | x | x | x | x | x |
Table 2:
| Groups | D | C | A | E | B |
| 1 | x | x | x | x | x |
| 2 | x | x | x | x | x |
| 3 | x | x | x | x | x |
| 4 | x | x | x | x | x |
| 5 | x | x | x | x | x |
Hi Anonymous
If your data is like the following image, you could try my method.
Open Power Query Editor and add a conditional column Sort Order.
Apply the changes in Query Editor and go to Power BI Desktop. Select Name column and sort it by Sort Order column.
After that, you will find the matrix visual display as what you expected.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
3 Replies
You need to use the Sort By Column feature. Please see this link.
Sort by column in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat
Hi Anonymous
If your data is like the following image, you could try my method.
Open Power Query Editor and add a conditional column Sort Order.
Apply the changes in Query Editor and go to Power BI Desktop. Select Name column and sort it by Sort Order column.
After that, you will find the matrix visual display as what you expected.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
