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

[@bhainsley]

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

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

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

[@lara4043]

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

[@welcometomathy]

can we do this to show growth difference?

[@lara4043]

thank you very helpful!

[@lara4043]

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

[@rangabeeram8382]

Thanks!

[@SolutionsAbroad]

Thank you!

[@lara4043]

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])

[@arbazahmad7177]

Great 👍