https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Variance-chart-help/m-p/2849576#M6042 <P class="lia-align-left">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</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Customer Ask" style="width: 802px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/806205iDEBC331F3214C200/image-size/large?v=v2&amp;px=999" role="button" title="Customer Ask.PNG" alt="Customer Ask" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Customer Ask</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pbi custom visual" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/806206i6D0CB04D981CBA05/image-size/large?v=v2&amp;px=999" role="button" title="image_2022-10-18_105713647.png" alt="pbi custom visual" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">pbi custom visual</span></span></P><TABLE border="1"><TBODY><TR><TD>FY</TD><TD>Target</TD><TD>Actual Billed</TD><TD>Forecast to Bill</TD><TD>Variance</TD></TR><TR><TD>21-22</TD><TD>235,000</TD><TD>50,000</TD><TD>142,000</TD><TD>-43,000</TD></TR></TBODY></TABLE> Tue, 18 Oct 2022 17:02:02 GMT Anonymous 2022-10-18T17:02:02Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Variance-chart-help/m-p/2849576#M6042 <P class="lia-align-left">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</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Customer Ask" style="width: 802px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/806205iDEBC331F3214C200/image-size/large?v=v2&amp;px=999" role="button" title="Customer Ask.PNG" alt="Customer Ask" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Customer Ask</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pbi custom visual" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/806206i6D0CB04D981CBA05/image-size/large?v=v2&amp;px=999" role="button" title="image_2022-10-18_105713647.png" alt="pbi custom visual" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">pbi custom visual</span></span></P><TABLE border="1"><TBODY><TR><TD>FY</TD><TD>Target</TD><TD>Actual Billed</TD><TD>Forecast to Bill</TD><TD>Variance</TD></TR><TR><TD>21-22</TD><TD>235,000</TD><TD>50,000</TD><TD>142,000</TD><TD>-43,000</TD></TR></TBODY></TABLE> Tue, 18 Oct 2022 17:02:02 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Variance-chart-help/m-p/2849576#M6042 Anonymous 2022-10-18T17:02:02Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Variance-chart-help/m-p/2854646#M6064 <P>This looks like a great opportunity for you to learn about the Deneb visual.</P> Fri, 21 Oct 2022 01:13:43 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Variance-chart-help/m-p/2854646#M6064 lbendlin 2022-10-21T01:13:43Z