Forum Discussion
Matrix Table
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:
Thanks
I have found a workaround by :
- Adding the "index" to the table
- Diabling the "Text wrap"
- Hiding the "Index" colmun after sorting.
Happy days!
3 Replies
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
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
I have found a workaround by :
- Adding the "index" to the table
- Diabling the "Text wrap"
- Hiding the "Index" colmun after sorting.
Happy days!
