Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data with dates from July 2020 through to July 2021 and I want to represent using a line chart. I have created a Date table with Month number 1 for June and linked to data. I am using Sort By Month Number but it shows incorrectly with June 2021 before September 2020.
Do I need to factor in Years with Month Number or is there a way for PowerBi to do this?
Solved! Go to Solution.
Hey @littlepatos ,
Power BI does not add the year to the month automatically, I'm also not sure, if you are using two columns on the x-axis or if it's one column.
If it's two columns just switch the order of the year/month column as I did in the following line chart:
If it's one column you have to create your own order.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
my mistake- it does display as I need when I use the expand button
Thanks @TomMartens much appreciated
using 2 columns, Month & Year but when I swithc them it only shows Year and then I need to expand to show Month. I want to be able to display Month & Year if possible?
Hey @littlepatos ,
Power BI does not add the year to the month automatically, I'm also not sure, if you are using two columns on the x-axis or if it's one column.
If it's two columns just switch the order of the year/month column as I did in the following line chart:
If it's one column you have to create your own order.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |