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 want to compare values from different periods (years). I want in Line Chart report to compare the values from different years month by month. The important columns are Date and Q-ty.
My data is:
I want to compare these last 3 years in Line Chart or any other which is suitable. The data in lines is just to show how it should looks it is not with real data. I have also a DATE table, if it will be needed.
Thanks in advance!
Solved! Go to Solution.
Don't know if it is too simplistic, but if you parse the date as 2 added columns (one for year and one for month), then create a line chart with Month as the Axis, Year as the Legend and Quantity as the Value, doesn't that give the effect you are looking for? I didn't add a measure to smooth out the charts, just did the basics and got this:
Hi @Anonymous,
I have created two measure based on what I understand from you,
See the gif,
I hope I made it clear.
Regards,
Siva
@Anonymous,
Have you tried calculated columns?
Yes , I have tried columns with YEAR() and MONTH(), but I don't know how to compae values from different years on one chart.
Hi @Anonymous,
I have created two measure based on what I understand from you,
See the gif,
I hope I made it clear.
Regards,
Siva
Hello,
Thanks a lot fort he quick answers. I have tried both methods and both of them worked. I have chosen the first one by shill1000, because it is simpler for manage.
The only difference is that I also have a Date table (the query for the date table is: = Query_Date(#date(2000, 1, 1), #date(2040, 1, 1), null) ), which is related to mine table by column Date and I have used Date[Date] as axis (Date Hierarchy - Month) and Date[Year] as Legend. Q-ty is in Values and it worked fine
Thanks a lot!
Don't know if it is too simplistic, but if you parse the date as 2 added columns (one for year and one for month), then create a line chart with Month as the Axis, Year as the Legend and Quantity as the Value, doesn't that give the effect you are looking for? I didn't add a measure to smooth out the charts, just did the basics and got this:
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |