sort column values in a matrix in a particular order

[nj17]

Hi All,

I need to show below column values in a particular sorted order in a matrix.

the order should be:

1.Total F

2.MULTI BRAND

3.Total H

4.Total Speciality

I have created a table manually and created the relationship with above table

but still I am not able to sort the businessgroup in required order

Kindly help

@Jihwan_Kim 

[Jihwan_Kim]

Hi,

I am not sure how your dataset looks like, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

- select the column name in the Field pane (Business group)

- click Sort by column

- sort by S.nl column

[nj17]

Hi @Jihwan_Kim  thank you

from your report can i use 'BusinessGroup' from Subgroup dataset and then sort the matrix.

when I use this it gives me incorrect order

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message.

Inside Subgroup table, Business Group column does not have a sort group column, so it is not sorted.

Only inside Group table, Business Group column has the sort group column, so it can be sorted.

If you willing to use Business Group Column from Subgroup table, but not from Group table, you have to create a sort group column for Business Group Column inside the Subgroup table, and then sort it by using sort group column from the same table.

When creating this, I suggest do this in Power Query Editor.

Please check the attached file.

[nj17]

Thank you so much @Jihwan_Kim 

can you also help me in resolving this

https://community.powerbi.com/t5/Desktop/Merge-2-different-datasets-having-different-columns-in-Powe...