The data in the table is
I am using weekend date as column values in the matrix table.
The ouput is
The matrix column header values in appropriate order. How to display the column header values in ascending order ?
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
@Anonymous clicked on (...) on top right corner and change the sort order.
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
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.
Proud to be a Super User!
You can go to Query Editor, sort the "weekend date" column in descending order, then add a index column from 1. Apply the change.
Go to Data type select the "weekend date" column, click on Sort by Column, choose Index column.
Best Regards,Qiuyun Yu
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.