Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am running in the following issue.
data is like this
date | Time spent |
2020-12-10 | 1 |
2021-01-04 | 4 |
2021-03-18 | 2 |
Current behavior
I got December 2020 coming after April 2021
Expected behavior
To have December to be before January 2021 in the graph
Thanks in advance for your help
Solved! Go to Solution.
@jbrolland , Try to sort again from three dots. I usually create a date table with month and month sort. I sort month on the month sort and use that.
But in this case, Dec will come after April because it December.
On X-axis put both month year and try. Let the year be on column too
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
@jbrolland , Try to sort again from three dots. I usually create a date table with month and month sort. I sort month on the month sort and use that.
But in this case, Dec will come after April because it December.
On X-axis put both month year and try. Let the year be on column too
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Perfect it worked, I actually just needed to Sort by month from the three dots menu
Thanks a lot
I check this too fast, it actually not sorting properly
Not super cleanas I don't have the month name but did not find any better
I was served by your solution! Thanks a lot
User | Count |
---|---|
104 | |
86 | |
80 | |
72 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |