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

[@sadiqabkr]

Excellent work. Very impressive. Thank you

[@DataSkillsCo]

Nicely done! That's elegant.

[@GiulianoCiolacu]

What a great idea! Thank you so much!

[@PratyashaSingh-v6y]

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?

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

[@balajis2269]

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

[@Patrick-d7t]

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?

[@fubdgshushujwse7484]

How do i add a legend to make it clear that they grey is a previous week and the current is blue ?

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

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

[@heidi45681]

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

[@datayoda74]

excellent video and will try to implement

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

[@Muhyd33n]

Thank you Fernan

[@anaheetaazizi4177]

Amazing, Thanks so much

[@mokjok5179]

super! i'm looking for overlap bar

[@marlonetzel6450]

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

[@jejetator]

well done Fernan!

[@roshanperera292]

How does this work in focus mode ?

[@deryansyah]

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

[@pthapa55]

nice example. Thanks

[@jennicas4165]

How do I export it as one?

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

[@nikhilsharma-yf3qm]

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

[@axan6000]

just one probably

[@centugurdag7776]

Great

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

[@arnithsoukharath5656]

How to solve Data Table showing just 1000 rows

[@cathrerinezetadrones3169]

🎉

[@ajjbs7580]

Outdated, i can only put 1 y axis data. WTF Microsoft?!?