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.
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
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.
@Anonymous clicked on (...) on top right corner and change the sort order.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
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.
Go to Data type select the "weekend date" column, click on Sort by Column, choose Index column.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |