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.
Hey all,
is it possible to sort the months in descending order in a matrix? So August is first at the top.
Thanks for helping.
Solved! Go to Solution.
Hi Azaterol,
This is how I would do it:
Go to data
In your Date table I would create 2 additional columns called 'MonthDesc' and 'MonthDescKey'.
MonthDesc = FORMAT('Date'[Date], "MMM")
MonthDescKey = 32 + (-1*MONTH('Date'[Date]))
Then sort 'MonthDesc' by 'MonthDescKey' (Option: Sort By column)
Once that is done you can go to report view open a table with 'Year' and 'MonthDesc' and sort by 'Year'.
There might be easier solution.
Hope this helps!
Hi Azaterol,
This is how I would do it:
Go to data
In your Date table I would create 2 additional columns called 'MonthDesc' and 'MonthDescKey'.
MonthDesc = FORMAT('Date'[Date], "MMM")
MonthDescKey = 32 + (-1*MONTH('Date'[Date]))
Then sort 'MonthDesc' by 'MonthDescKey' (Option: Sort By column)
Once that is done you can go to report view open a table with 'Year' and 'MonthDesc' and sort by 'Year'.
There might be easier solution.
Hope this helps!
@Luuky thank you!
now I have sorted the months in descending order, I would also like to sort the days in descending order how would you do that for the days?
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |