Forum Discussion
Descending Order when using date in a matrix
dear all,
i have the following matrix visual:
I want the the most recent year to be visualized on the left in a descending order.
How can I achieve this?
Thanks a lot
here is a workaround, try to create a order column in PQ and sort the year column by the order column.
3 Replies
here is a workaround, try to create a order column in PQ and sort the year column by the order column.
- Hi powerbricco
Please follow the below steps:
Sort the column used in Columns area (Date/Year) in descending order
- Go to the Fields pane.
- Locate your Date column (or the Year field you're using in the Columns well of the Matrix).
- If you're using a Year column derived from a date (e.g., Year = YEAR([Date])), make sure that field is used in the matrix.
- In the Matrix visual, click the dropdown arrow on the year header (top of the matrix columns).
- Choose "Sort descending".
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together! Hi powerbricco
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
