Forum Discussion
robbert-bi
Helper I
Helper IHow to let user sort matrix by specific months?
Hi. I have a matrix in Power BI with "Medewerker" in the Rows, "MMM-YYYY NL" (showing the month) in the columns and a measure called "% Declarabel" in the Values. See the screenshot for an example. T...
Hi robbert-bi
Matrix can be sorted by the total column or by the row category. Column category is sorted alphabetically in ascending order or by custom column sort. If you want to sort it by the total row, attached is a round about way to do it.
nandic
Resident Rockstar
Resident Rockstarrobbert-bi , you are correct. There is no default option in matrix visual to sort by specific column (month in your case).
As you already mentioned, adding measure/column for each month is not ideal solution.
Give a try to Zebra BI Tables custom visual. It gives allows you to sort by columns - just check if it requires paid license or that feature is free.
I think that also license is not that high on a yearly basis, worth checking.
Cheers,
Nemanja