Matrix Table

[H_insight]

Hi all,

I am trying to replicate the below view in PBI, but I am hving a couple of issues:

- Unable to use the "Sort By" as one column "Location" has duplicate values. Not sure on the best way to overcome this?

- The closest I got was with "Table" but not matrix: (again the sorting is not helping here)

Here is the expected view:

Sample File.

Thanks

[H_insight]

@amitchandak I am aware that I have multiple values for the location column, but that's why I asked the question to get some feedback and potential solution. Each location would have many "text" values. In the sample file, there is an index that I would like the sorting to follow. Is that achievable? The 2nd part of the question is, can I do multi-sort in matrix table? thanks

[H_insight · Accepted solution]

I have found a workaround by :

• Adding the "index" to the table
• Diabling the "Text wrap"
• Hiding the "Index" colmun after sorting.

Happy days!

[amitchandak]

@H_insight , You have more than one sort value for a given location.

On a table visual check location and count of index. find the location with more than one index and fix those