topic Re: Variance chart help in Custom Visuals Development Discussion

Variance chart help

Anonymous — Tue, 18 Oct 2022 17:02:02 GMT

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

Re: Variance chart help

lbendlin — Fri, 21 Oct 2022 01:13:43 GMT

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

Re: Variance chart help

PBIdashboards — Mon, 15 Jun 2026 03:25:35 GMT

The Deneb suggestion works for the custom chart visual. For the table/matrix side of the same report (showing the variance numbers per vendor alongside the chart), Flexa Tables on AppSource might be simpler, it supports custom variance formulas and conditional formatting (red/green) as built-in options without custom Vega specs.

If the goal is purely the chart visual, Deneb is the right tool. If you also need a variance table that Finance users can explore themselves, Flexa Tables is worth a look. Search "Flexa Tables" on AppSource.

Re: Variance chart help

masonreed11t — Sat, 20 Jun 2026 04:38:01 GMT

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.