cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

 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 OutputMy Output

 

Expected Output: Each Year has a different line.

 

Expected OutputExpected Output

 

Thanks in Advance. 

 

Cheers, 

Vani

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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.

multi lines.png

 

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.

 

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

@vani2506 

 

Please see if this is what you want?

1.PNG

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

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

2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

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.

multi lines.png

 

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.

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors