Forum Discussion

SonyT's avatar
SonyT
Frequent Visitor
7 years ago

Overlapping Bar Chart

Hi. I'm fairly new to Power BI and I would like to create a bar chart within a bar chart. Is there a visual available for this as I have been unable to find one? For example I would like to show Current Month vs Current Month Last Year using a bar chart, with a small/narrow bar within a current bar. Perhaps this is called an overlapping bar chart?  Many thanks.

Need Help

7 Replies

    • SonyT01's avatar
      SonyT01
      Regular Visitor
      4 years ago

      Thank you R, that visual looks like just what I need.

  • calerof's avatar
    calerof
    Impactful Individual
    7 years ago

    Hi SonyT ,

     

    You could try to use the Clustered Column Chart, where in values you add current revenue and previous year revenue.

     

    Hope it helps.

     

    Regards,

     

    Fernando

     

  • Alia222's avatar
    Alia222
    New Member
    4 years ago

    Hi SonyT  you can add the overlapping bar chart visual at the visualization pane from Get more visual. Hope this helps!

  • SonyT's avatar
    SonyT
    Frequent Visitor
    7 years ago

    Thank you for your response Fernando.  It seems there doesn't seem to be a visual that allows for a bar chart that overlaps. Perhaps we will have to go with your suggestion for now. Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I know its not what you are looking for but you could use the line and clustered column chart and plot the same month last year on the line and the current on the bar. (or the other way around)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    If you wish make a Bar plot similar to Power BI's Logo (on Bar coinsiding the other vertically), and not need a lipstick chart, you can create it using a python visual in Power BI. you can easily define, start point of Bars on x-axis, as well as their width.