COMPARE TWO PERIODS and SHOW DIFFERENCE NATIVELY // Beginners Guide to Power BI in 2023

In this video were going to cover how you can visualise a change of value between two periods and show their variance in percentage natively using the simple bar chart in Power BI

🕓 TIMESTAMPS
0:00 - Intro
02:35 - Setting up DAX
05:21 - Formatting the bar chart
10:43 - Showing Variance
-

📣 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

[cnieberd]

Great intro as always - just one short remark - you don't need to have to add the "arrow up" / "arrow down" (min 12:00) as you have the (1) difference arrow, (2) colour coding in red and green and the (4) negative/ positive sign before the number . I'll take it as an alternative way. Multiple encoding of the same information may distract people.

[kunwang]

Great. Really smart method to create this kind of chart. hope more such kind of chart technic especially on other genious solution of Gustaw Dudek

[Ali-dkrr]

This is amazing! So helpful, thanks for the video.

Also, do you have a solution for the error bars not fitting within the Y axis range? I've tried creating a measure of Compared Value + Compared Value *0.1 to give it 10% extra room, but it starts the error bar in the wrong spot. Any thoughts?

hello, fantastic video and very useful. however, i cannot find or insert error bars anywhere? any help would be hugely appreciated. thank you