Forum Discussion
Sorting Matrix rows - this should be easy
Yes if it's from the same dimension (table). If you want it by Year and Month then you should replace those two columns with a Month-Year column and have that column sorted by your Date field. If you don't already have a column for that, it could easily be created by adding a new calculated column:
Mnth-Year = FORMAT([Date], "MMM YYYY")
Yes if it's from the same dimension (table). If you want it by Year and Month then you should replace those two columns with a Month-Year column and have that column sorted by your Date field. If you don't already have a column for that, it could easily be created by adding a new calculated column:
Mnth-Year = FORMAT([Date], "MMM YYYY")
Aha, I added the column you mention but couldnt set "sort by" date on it as the date column had multiple values per month year grouping (as it would do) BUT building in your solution i added a calculated sort coulmn and then sorted the visual by that ! so thank you very much for your solution as it allowed me to fix it it!
Mnth-Year-sort = VALUE(Dates[Calendar Year] & "00") + Dates[Calendar Month]