Power BI Desktop

[Pooja_Mishra]

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

[v-jingzhang · Accepted solution]

Hi @Pooja_Mishra 

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.

[Anonymous]

@Pooja_Mishra Hover over the table and when you see the ellipses , click on that and you will find an option to Sort.

There you can select the way you want.

[mahoneypat]

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