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
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: [e-mail]
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 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

[@GiulianoCiolacu]

What a great idea! Thank you so much!

[@DataSkillsCo]

Nicely done! That's elegant.

[@datayoda74]

excellent video and will try to implement

[@pthapa55]

nice example. Thanks

[@anaheetaazizi4177]

Amazing, Thanks so much

[@jejetator]

well done Fernan!

[@heidi45681]

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

[@user-sb9ol6ib5i]

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?

[@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. 😅

[@SM23Studio]

it's available in 2024 february update - so it's finally natively supported

[@kuuuyajim]

I overlooked the blog update. 😅

[@SM23Studio]

@@kuuuyajim actually it was not mentioned in the blog. I only saw Gustaw Dudek’s linkedin post about this feature. I immediately used it in my actual project… so helpfuk

[@mokjok5179]

super! i'm looking for overlap bar

[@sandeepb980]

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

[@centugurdag7776]

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 ?

[@roshanperera292]

How does this work in focus mode ?

[@umeshbasnet7598]

I am facing The syntax for 'RETURN' is incorrect. (DAX(DIVIDE(Risk_Assessment[Risk score current],Risk_Assessment[Prv. risk score]) - 1RETURN)). problem while creating a upward or downward trend

[@emanueledelzoppo5164]

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.

[@hasnainakram1530]

use custom labels

[@jennicas4165]

How do I export it as one?

[@marlonetzel6450]

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

[@centugurdag7776]

Great

[@nikhilsharma-yf3qm]

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

[@axan6000]

just one probably

[@cathrerinezetadrones3169]

🎉

[@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.

[@arnithsoukharath5656]

How to solve Data Table showing just 1000 rows

[@meow01_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