VISUALISE variance in Bar Charts // Show Over Target or Under Target // Beginners Guide to Power BI

[@supremennn3829]

Cool video. I've changed around the target values to be last years values for my use case. Works fine thanks

[@rangabeeram8382]

Thanks!

[@SolutionsAbroad]

Thank you!

[@bhainsley]

Thank you! Great technique for a visual that gives the user even more useful information at a glance!

[@laraSheDigiConstruct]

thank you very helpful!

[@marinafalkner8968]

Great video, thanks! Would it be possible to create bars with different colors for every month?

[@DenysFormiga]

Make a dax like a "data label color" with the hex codes by month.

[@arbazahmad7177]

Great 👍

[@welcometomathy]

can we do this to show growth difference?

[@karnikkalani1516]

I want to do the same for margin percentages but its not happening for me it 3 values don't show up as clear as yours. and the percentage also has to be calculated its not in a column as i used a measure earlier

[@shwetkumar1719]

what doest increment does as you have taken it = 10

[@laraSheDigiConstruct]

pls check, keep getting error Over Target = VAR _Headcount=Sum(Headcount[Actuals] Returns If (_Headcount > Targgggt[Targgggt Value]), _Headcount -Targgggt[Targgggt Value]

[@laraSheDigiConstruct]

i have 2 dates to compare using bars & its not working

[@laraSheDigiConstruct]

please comment on this. it's not working for me. than you. Over Target = Var DATEFst=SUM(DATEFst[Fst HODate]) if(DATEFstFst [HODate]>DATETargt[],DATEFst[Fst HODate]-DATETargt[Targ HODat])