Forum Discussion
Variance chart help
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 prob...
masonreed11t
Advocate II
Advocate II
The issue is probably not the visual itself but the variance logic. Most Power BI variance visuals expect something like Actual - Target, so they won’t calculate the way your customer wants.
Create a separate measure for the customer’s formula:
Variance = ([Forecast] + [Actual]) - [Target]
Then use conditional formatting for the variance text:
Color = IF([Variance] < 0, "Red", "Green")For the layout, a combo chart can get close (Target + Forecast as lines, Actual as bars). If you need exactly two vertical markers and a single actual bar with dynamic colored variance text, you’ll likely need a custom visual like Deneb because standard visuals have limitations.