Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vani2506
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
v-yingjl
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
v-yingjl
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.

 

amitchandak
Super User
Super User

@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
Super User
Super User

@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!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.