Overlapping Bar Chart

[SonyT]

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.

[Varkha_19]

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.

[radhey_rec]

Hi @SonyT ,

Perhaps you are needing a lipstick chart:

If so, you can check:

https://appsource.microsoft.com/en-gb/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.lip...

OR

https://pbivizedit.com/gallery/lipstick-column

Thanks,

-R

[SonyT01]

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

[Alia222]

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

[SonyT]

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]

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)

[calerof]

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