Sort columns header by value

[Fragan]

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 ?

[amitchandak]

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

[Fragan]

Thats not what im looking for, i want to sort the columns(which are dates) by Attribute value

[v-xuding-msft]

Hi @Fragan ,

Unfortunately, it is not supported to sort by value for now. 

Please vote up the idea to get the feature fixed quickly. There are already hundreds of people vote up. I think it will be implemented soon.

Matrix - Sort rows by value (asc or desc) 

[amitchandak]

@Fragan , In Matrix, Once you put column, you can only sort on the grand total of measure. Using the 3 dots