Forum Discussion
Sort in Matrix Visual
I wanted to provide my work around I used incase anyone else gets stuck.
I used the Min of the Sort column as the last value on the matrix. I then sorted it and hid the column using this video: https://www.youtube.com/watch?v=1bp_e-ik7aA
hey,
if you go directly to the table not the visual, you can dort the columns using a reference the sort column for the whole dataset, so when you get that data on the visual it will sorted,
if not also you can try to put the sort column a value field and in the options section of the visual you can sort the visual by that field values
Thank you so much for the quick response!! The issue is that the Rows or table columns have duplicates which prevents Power BI to Sort By
create a custom column that concatenate the category,brand, sub brand, delite the index column or try using the index column for the sort reference, or the custom column also. try both and see wicth works for u
Yes, I tried that as well on my real dataset. i created a concatenated column. It works if I use the concatenated column in the matrix but I want to use the original columns to give the drill down appearance of a matrix.