Line and Clustered Column Chart w/ Multiple Columns and Lines

[KendallBrown13]

I'm looking to replicate this image in power BI. 

So far this is as close as I have been able to get. 

Essentially I want the to be able change which lines and columns are visible simply based on the year. Just like there are multiple columns I want there to be multiple lines as well (for each year). Any one have any ideas? 

Thanks! 

[Mayank_Yavda]

Hi @KendallBrown13,

Here is Line and clustered column chart With Custom Tooltip which will help you to get more than one line chart with clustered chart. You need to Modify the visual using PBIVizEdit tool, and add any number of line chart on top of it. Hope this helps you.

Line and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.com

Download link for the custom visual file in this page

https://pbivizedit.com/gallery/line-and-clustered-column-with-custom-tooltip 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

• anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

[v-chenwuz-msft]

Hi @KendallBrown13 ,

Unfortunately, the line and chart seems not support to do that. But you can create multiple measure for line as a workaround.

2021 line = CALCULATE( SUM( Table[Values] ) , Table[year] = 2021)

2022 line = CALCULATE( SUM( Table[Values] ) , Table[year] = 2022)

Best Regards

Community Support Team _ chenwu zhu

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

[analitika123]

But will 20-30 years period, then 20-30 measures will be created?