How to make variance chart in Power BI to measure performance

Do you want to create a variance chart (or visual) in Power BI to measure actual vs. target performance? This video explains how to create such a chart with synchronized sorting and interactions. We will use conditional formatting, visual grouping to achieve a cohesive, simple, clean & elegant variance chart in Power BI.
For a sample workbook and more visit
chandoo.org/wp/variance-chart...
#VarianceChart #PowerBIVisuals #BudgetvActual #ActualvTarget

[@merrillmchenry1450]

Chandoo - you the Man once again!! So many people owe you for your kind expert assistance. ME TOO!!
THANKS MUCH AND BEST WISHES!!!

[@chandoo_]

Glad to help. 😍

[@shanitasojan3282]

Beautifully explained :) Thanks for sharing!

[@lpcoolee]

You are absolutely awesome Chandoo! Thank you for your direction - brilliant video

[@FullMoonHatch]

Thank you! Great explanation!

[@virgie1728]

This really saves the day, thank you, Chandoo and more power!

[@chandoo_]

Glad to hear that!

[@moroformat]

Best solution for a semi-custom visual in power bi. Thanks !!

[@chandoo_]

Thanks Moroni...

[@wayneedmondson1065]

Thanks Chandoo.. interesting video with some good techniques. Thanks for sharing them. Thumbs up!!

[@chandoo_]

Glad you liked it!

[@kevinharilal8288]

You the man. Well done, cool simple charts

[@chandoo_]

Thanks Kevin :)

[@funwithfatty6067]

Thank you Chandoo

[@satishkumardommeti8282]

Cool idea.

[@beachbum285]

Very helpful thank you!

[@chandoo_]

You're welcome!

[@shoaibrehman9988]

Thanks good info

[@pahan95]

thanks chandoo!

[@chandoo_]

You are welcome.

[@amal2503]

Very good tricks! Simple but effective.
Do you have any visual for OEE?

[@fajnefajne4339]

Great explanation. Thank you.

[@chandoo_]

Glad it was helpful!

[@ganjingwen848]

Thanks for the good content!!

[@chandoo_]

Glad you enjoy it!

[@sravankumar2617]

Hi Chandu... Ur new look is awesome

[@karinahulka9980]

thanks for the video. I was tasked to show the variance over 4% and tooltips option doesn't work in this case for sorting(

[@lavanyak5192]

Is there a way to include drilldown capability on both the visuals on single click ?

[@sukhomoyb]

Great Tip Chandoo

[@chandoo_]

Thanks Sukhomoy...

[@JKTipsTricks]

Thanks chandoo ... Useful information of power IB ... NEW FRIEND HERE

[@chandoo_]

Thanks and welcome

[@koenatshegofatso5707]

thank you, really appriciate it

[@chandoo_]

You're welcome!

[@AbdulRahman-zl4jv]

Thanks..

[@TheAztexan]

Can you compare the actuals Month-Over-Month variance by product? Ex: Product FHEJ actuals Month-over-Month increased/decreased by $ and by %.

[@nibinjoseph3725]

Hi Chandoo. From where can i find the data set to work on this project?

[@rencyl5611]

👍🏻👍🏻

[@Aaditya10021]

Hi Chandoo,
Thanks for the great contents as always.
I just wanted to understand how to plot values against secondary axis in PowerBI?
Any solution for it?

[@chandoo_]

Hi Aaditya… you can use secondary axis in a few types of visuals in new version of Power BI. Give it a try.

[@Mamtha7272]

super

[@sands7779]

useful variance chart where preference not to use marketplace visuals thank you

[@chandoo_]

Glad it was helpful!

[@casper3842]

at last! i saw the master face!

[@padmanavaseth9872]

Can I plot a (ShareMarket) Stocks candle chart with volume.

[@alm3tasem]

Hi Chandoo,
For chart title, it has two different font sizes, is this title a text box, or the native title property for the visual?
Thanks

[@chandoo_]

It is a textbox. You can select parts of text and apply different colors, sizes etc.

[@SocialMedia-io1tz]

I am calculating varance in % but for me it is giving value as 151.00%
Instead of 1.51%
I am dividing delta/actual setting to percentage
Because on the actual basis I want to calculate variance
But getting 151.00%

[@lukev730]

Hi Chandoo
Nice video. Regarding Zebra BI has amazing visuals even for Excel. Can you please create something in excel same like Zebra BI visuals. Because zebra bi is very expensive.
Thank you

[@chandoo_]

Thanks for the comments Luke. I will try.

[@sssuresh2007]

Hi Sir, I see the issue when I scroll on graph1 the graph2 variance is not moving. Since I have huge data in my dataset. Can ou suggest,

[@chandoo_]

Unfortunately, synchronized scrolling is not possible with this technique. I suggest using a table when you have such large data.

[@saurabhkharwandikar9640]

Hey, can you share the excel data file, for practice. Would really help

[@b0hemian721]

Hi! Please share the formula used for both Variance and Variance%. Thank you

[@chandoo_]

Please refer to the sample workbook. Link is in the description.

[@b0hemian721]

@@chandoo_ Can u pls help me on how to use two columns frOm different tables againsT month?

[@b0hemian721]

@@chandoo_ to visualize them in 1 graph

[@rajeshkhanna8709]

Hi
I Have question that
Min Or Max
In table haveing
highest Discount
or
lowest Discount
Which supplier have
min Discount
I want ans like below
Mohammed
1
I want ans
Min Discount and Supplier name
That into CARD Visual
When we display same ans on card visual ans should be asc

[@chandoo_]

hmm... see this video for an example - czcams.com/video/n7gAJMBdJ8k/video.html

[@SKAMRANPASHA]

What's with the sudden beard