Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
masonreed11t
Icon for Advocate II rankAdvocate II
3 months ago

Try creating a separate DAX measure for the customer formula:

Variance = (Forecast + Actual) - Target

Then use that measure for conditional formatting (negative = red, positive = green). A combo chart with target/forecast as lines and actual as bars may fit the requirement better than the built-in variance visuals.