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.
Hi all,
Is it possible to sort data in a matrix from newest to oldest?
Opposed to oldest to newest - as shown below.
thanks,
Hi @HenryJS ,
Have you checked the suggestion by @amitchandak ?Is your issue solved now?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@v-kelly-msft I haven't been able to change the order yet. Is there a simple way to do this within Power BI?
Hi @HenryJS ,
Sorry for the late reply!
First create 2 columns as below:
DateNumber=DAY('Table'[Dates])
Rank= MAX('Table'[DateNumber])-'Table'[DateNumber]
Then duplicate the dates column;
Finally select the duplicate column >sort by>Rank;
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@HenryJS ,
Create in your date table
Date 1 = Date
Date Rank = rankx(all(Date), Date[Date],,desc,dense)
Sort Date1 and on Date Rank and use Date 1 in your visual
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |