Forum Discussion

KendallBrown13's avatar
KendallBrown13
Frequent Visitor
4 years ago

Line and Clustered Column Chart w/ Multiple Columns and Lines

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! 

Need Help

3 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      analitika123
      Icon for Helper II rankHelper II
      3 years ago

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

  • Mayank_Yavda's avatar
    Mayank_Yavda
    Icon for Resolver II rankResolver II
    4 years ago

    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