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.
First time using a Date Table because I keep hearing I should. Unfortunately visuals are sorting Month names alphabetically. To try and get around that I have added the Month Number to my Date Table. Unfortunately even that is sorting alphabetically. How in the world can get the months to simply appear in the order in which they occur?
Example of what is happening:
Apr, August, ...
Month #:
1, 10, 2, 3,...
Desired Result:
January, February..
Month#:
1, 2, 3...
Screenshots of the problems:
Here is the DAX I have used/modified trying to get the Date table to cooperate:
Solved! Go to Solution.
Hi @Brenden
After adding the month number, you need to modify the sort order of months names by these numbers:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Brenden
After adding the month number, you need to modify the sort order of months names by these numbers:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |