Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
Our charts axis are dates and Everything was ok until these dates started to be in Jan 2021, and now the columns are not in the right order:
And this is the column I'm using in the axis:
And that's how it looks like when I sort by month (asc/ desc):
When we delete the data of january from the source the months become well ordered, so the issue is about the data of 2021 which is coming before the months of 2020.
Any suggested solution.
Thank you in advance.
Solved! Go to Solution.
Hi. It doesn't seem to be a problem at all. Check how you are drilling down. The two down arrows will expand next level summarizing all years. That's why January will always be first. You have to use the icon with one arrow that splits in two right next to the two down arrows. Check the gif out (January = enero). The picture has as axis Year and Month Name (without quarter and day)
Hope that helps,
Happy to help!
Hi. It doesn't seem to be a problem at all. Check how you are drilling down. The two down arrows will expand next level summarizing all years. That's why January will always be first. You have to use the icon with one arrow that splits in two right next to the two down arrows. Check the gif out (January = enero). The picture has as axis Year and Month Name (without quarter and day)
Hope that helps,
Happy to help!
Hi @ibarrau,
Thank you a lot for your help and your demonstration, you saved me.
I did what you mentioned in your answer, I included the year in the chart axis and right now it looks like this:
Do you think I can also hide the year label from the charts right now?
Thank you again.
I'm not sure if you can get rid of the year. I wouldn't recommend it because it might be confusing for the final user without it :S
Happy to help 🙂
Happy to help!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |