Variance chart help

[Anonymous]

Hi All, I need a help in variance chart. Customer is asking for the first visualization and i was able to produce the 2nd one with the custom visualization "Barchart with relative variance". The problem with it or any other variance chart i am using is the variance isn't being calculated the way customer is wanting. Customers variance formula is variance=(forecast+Actual)- target. and the visualiation should ideally contain two vertical lines(target and forecasted) and one bar (actual). if the variance is negative, text should be red and if positivem text should be green

Customer Askpbi custom visual

FY	Target	Actual Billed	Forecast to Bill	Variance
21-22	235,000	50,000	142,000	-43,000

[lbendlin]

This looks like a great opportunity for you to learn about the Deneb visual.