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.
Hello, I'm trying to get my matrix visual to sort in month's order but since the month names are in text, it's automatically sorted alphabetically. I have tried several methods to fix this but none of them helped:
1. I added a Data table which has the month IDs and joined it to the Month column on my main table ... did not work. I'm unable to sort in the main table as my source is DirectQuery.
2. Created a calculated column via Dax (see below) so this can be used instead. However, I'm just getting a "circular dependency" error was created instead when trying to sort Month by the Month_Number column.
Thank you
Solved! Go to Solution.
The simplest way is to use dates instead, and format the date as "mmm".
The simplest way is to use dates instead, and format the date as "mmm".
I don't know why I didn't think of this sooner. This worked so well, thank you!
Basically I added my "Date" column to the "Columns" section of the matrix, and removed Year Quarter and Day and it stays in order!
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |