Compare values by year in PowerBI Desktop

[Anonymous]

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!

[shill1000 · Accepted 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:

[SivaMani]

@Anonymous,

Have you tried calculated columns?

[Anonymous]

Yes , I have tried columns with YEAR() and MONTH(), but I don't know how to compae values from different years on one chart.

[SivaMani · Accepted solution]

Hi @Anonymous,

I have created two measure based on what I understand from you,

1. PYR - previous year Qty
2. TWOYRBCK = Qty 2 years ago

See the gif,

I hope I made it clear.

Regards,

Siva

[Anonymous]

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!

[shill1000 · Accepted 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: