cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

How to sort the matrix column header values

The data in the table is 

 

 

Pic1.PNG

 

 

I am using weekend date as column values in the matrix table.

 

 

The ouput is 

 

Pic2.PNG

The matrix column header values in appropriate order. How to display the column header values in ascending order ?

4 REPLIES 4
Highlighted
Anonymous
Not applicable

The matrix column header values are 11/1/2018,11/8/2018,11/16/2018,11/24/2018..... 1/05/2019,1/12/2019. It's in ascending order.

 

My expectation is like 1/12/2019 ,1/05/2019,...............11/24/2018,11/16/2018,11/8/2018,11/1/2018

Highlighted

@Anonymous clicked on (...) on top right corner and change the sort order.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted

You will need a "Sort By" column. See attached, Table9, Page 8.

 

Date is "Sorted by Column" the SortBy column. You access this by clicking on Date and then go to the Modeling tab.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Hi @Anonymous,

 

You can go to Query Editor, sort the "weekend date" column in descending order, then add a index column from 1. Apply the change. 

 

q6.PNG

 

q3.PNG

 

Go to Data type select the "weekend date" column, click on Sort by Column, choose Index column. 

 

q4.PNG

 

q5.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors