Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Fragan
Helper III
Helper III

Sort columns header by value

Hey,

I have this table :

image.png

 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 :

image.png

 

Anyone knows how i can achieve this please ?

4 REPLIES 4
amitchandak
Super User
Super User

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

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) 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.