cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sivareddy Regular Visitor
Regular Visitor

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
sivareddy Regular Visitor
Regular Visitor

Sort Column header values in matrix visulization

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

Super User
Super User

Re: Sort Column header values in matrix visulization

@sivareddy 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 Datanaut!

www.perytus.com
(MVP Data Platform)


Super User
Super User

Re: Sort Column header values in matrix visulization

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.


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

Proud to be a Datanaut!


Moderator v-qiuyu-msft
Moderator

Re: How to sort the matrix column header values

Hi @sivareddy,

 

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.