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.
I have a bar chart using dates. I have dates that are from Dec of 2019 going through July 2020. When I put this into a bar chart it is putting Dec last even though the year when the transactions occured was 2019 which should be first. As you can see in the attached picture it is putting Dec last. It looks like it's not taking into consideration the year.
I have built a date table but still no answer. How do I get the months in order first by year?
Solved! Go to Solution.
@WILLIH , there is no year with month. It does not know dec is before July
Use Month year.
You need to add a year to your month.
On your data tab, check that date is set to date Hierarchy, and ensure Month and year are selected.
Hi @WILLIH
You need to know when you click "go next level in hierarchy", it will show month level, so it will sort by month or alphabetically. So I think you could click below button, which will soty by year-month
Or you also could refer to @Anonymous ' s suggestions, create a year column.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You need to add a year to your month.
On your data tab, check that date is set to date Hierarchy, and ensure Month and year are selected.
@WILLIH , there is no year with month. It does not know dec is before July
Use Month year.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |