Forum Discussion
Sort columns header by value
Hey,
I have this table :
And i want to be able to sold the date columns by Attribute value, for example if i sort date by Attribute1 values i should get :
Anyone knows how i can achieve this please ?
4 Replies
Create a New Month Year column
Create a desc sort column for that
Month Year = format([Date],"mmmm-yyyy")
Month year Sort =format([Date],"yyyymm")
Rank= Rank(all(Table),[Month year Sort ],,desc,dense)
Sort month year on Rank column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thats not what im looking for, i want to sort the columns(which are dates) by Attribute value
Fragan , In Matrix, Once you put column, you can only sort on the grand total of measure. Using the 3 dots
