How to show OVERLAPPING BAR CHARTS in Power BI // Show and Compare Variance

In this video were going to cover how you can create an overlapping bar chart, visualising two sets of data showing variance along with colours and labels.

🕓 TIMESTAMPS
0:00 - Intro
02:45 - Start
06:41 - Formatting
10:04 - Setting Max Axis
12:43 - Labels
14:24 - Colours

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[sadiqabkr]

Excellent work. Very impressive. Thank you

[kuuuyajim]

I hope they could add this a native functionality since it would really be helpful in comparing data. In scenarios like this, I miss working in Excel. 😅

[balajis]

Excellent ideas, thanks for posting, i am looking the same to present..👌👍

[PratyashaSingh-vy]

Thank you! but when I open the overlaying chart in focus mode after grouping them, only one of them appears. Is there a way to have both the chart view together in focus mode?

[emanueledelzoppo]

Great video! Is it somehow possibile to show the data labels for previous and current month? Like not only the variance, but also the value representing the height of the bars.

[mokjok]

super! i'm looking for overlap bar

[marlonetzel]

nice video. But it very difficult to this with a multi color backround. Any tips on that?

[datayoda]

excellent video and will try to implement

[Patrick-dt]

I am a beginner and my chart isn't working as expected. When I select a specific month (for example, November 1997), it only displays the sales for that month and not the previous month's sales. However, when I remove the date filter, it shows both - the current and previous month's sales. Could you please explain why the calculation for the previous month is affected by the date filter?

[heidi]

is it possible to show the data labels in bar charts, like can we show percentage on labels as well?

[sandeepb]

Is there any way to add label to show which color is current year sales vs previous year sales

[centugurdag]

how we would calculate max axis if our chart would have as x axis dates and y axis one with monthly sales and the other last year same month ?

[umeshbasnet]

I am facing

The syntax for 'RETURN' is incorrect. score current], Risk_Assessment[Prv. risk score]) - 1RETURN)). problem while creating a upward or downward trend

[deryansyah]

how about creating this chart type based on last year same month?

[nikhilsharma-yfqm]

What if you focus or make the chart full screen, will it be the same visual??

[MrAszpic]

Warning: You have to be overly extremely careful when editing this type of overlapped charts. A single difference in font type or font size or a single different setting in the column charts can make the values of the "invisible axis chart" differ from the axis you see.

[meow_MK]

This is really cool, however legends are wenr off. What is the way to keep the legend on for current amd last year data

[arnithsoukharath]

How to solve Data Table showing just 1000 rows