Multiple year line in single line chart

[Mahadevaraobc]

Hi All,

I have a column in yyyymm format, i have converted this to month format.

How do i display multiple year as different line in single line chart? when i try to add year to legend field is shows 1 single line for all year but not different line.

Thank you in advance..

[kcantor · Accepted solution]

@Mahadevaraobc 

You will need to create different calculations for each year to display the way you request.

This Year Sales = SUM(FactTable[LineSales])

Last Year Sales = CALCULATE([This Year Sales], DATEADD(Date[DateKey], -1, year))

2 Yr Prior Sales = CALCULATE([This Year Sales], DATEADD(Date[DateKey], -2, year))

Then drop these as measures on the visual using your date table month column for the axis.

If I have misunderstood your question, please provide some sample data and more information on the solution you are hoping to see.

[kcantor · Accepted solution]

@Mahadevaraobc 

You will need to create different calculations for each year to display the way you request.

This Year Sales = SUM(FactTable[LineSales])

Last Year Sales = CALCULATE([This Year Sales], DATEADD(Date[DateKey], -1, year))

2 Yr Prior Sales = CALCULATE([This Year Sales], DATEADD(Date[DateKey], -2, year))

Then drop these as measures on the visual using your date table month column for the axis.

If I have misunderstood your question, please provide some sample data and more information on the solution you are hoping to see.

[Mahadevaraobc]

Hi kcantor,

Thanks for replying.

My data looks like this.

Row Labels201720182019Grand TotalGrand Total241204229674

201701	19			19
201702	29			29
201703	30			30
201704	19			19
201705	18			18
201706	14			14
201707	23			23
201708	17			17
201709	10			10
201710	6			6
201711	36			36
201712	20			20
201801		19		19
201802		29		29
201803		30		30
201804		19		19
201805		18		18
201806		14		14
201807		23		23
201808		17		17
201809		10		10
201810		6		6
201811		13		13
201812		6		6
201901			25	25
201902			29	29
201903			30	30
201904			19	19
201905			18	18
201906			33	33
201907			23	23
201908			17	17
201909			10	10
201910			6	6
201911			13	13
201912			6	6

and my chart comes like this .

But i want the all years in different line. how do i do that.

Thank You.

[kcantor · Accepted solution]

@Mahadevaraobc 

Put your months for your x axis. Then create the calculations and drop them on the chart.