Help! I want to add multiple lines in clustered Column chart.

[vani2506]

 I want to add multiple lines in clustered Column chart. Do I need to create multiple measures for each line? Is there any easy solution? Ideally I want a line which shows the Total calls for each year at different point in time. 

My Output looks like this 

 My Output

Expected Output: Each Year has a different line.

Expected Output

Thanks in Advance. 

Cheers, 

Vani

[v-yingjl · Accepted solution]

Hi @vani2506 

If you want to get the same output as you expected, I think create multi measures is a direcrt solution because one line represent one value in the chart.

Attached my sample file that you can refer: add multiple lines in clustered Column chart.pbix 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@vani2506 , Multiple lines using legend are not yet supported on the Clustered line chart yet.

Mutiple meausres seem like an option. Of check for some custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[ryan_mayu]

@vani2506 

Please see if this is what you want?

you need to create a calnder table and create relationship between them.

ytd = TOTALYTD(sum('Table'[value]),'datetime'[Date])