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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

Sort columns header by value


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 ?

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

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.