Forum Discussion

JadenWelch's avatar
JadenWelch
Frequent Visitor
2 years ago

Urgent Request: Variance Reporting

Reposting because this is an urgent request if possible: I have a Power BI matrix where I have the field "Scenario" as my Columns, the field "Industry" as my Rows, and two Values, Revenue & Expens...
Need Help
Slim-'s avatar
Slim-
Frequent Visitor
2 years ago

Hi JadenWelch,

 

In a simple way you could create a calculated column :

Diff = IF('Table'[Scenario]="Current Forecast",-1*'Table'[Amount],'Table'[Amount])

And use this column as value while activating the columns total in your visual parameters. However it adds "-" in front of numbers.

 

What do you think of this answer ?

 

Regards,

JadenWelch's avatar
JadenWelch
Frequent Visitor
2 years ago

Hi Slim- 
Thanks for the comment, however, that wouldn't quite meet my needs. This report is viewed by leadership and would not make sense to see negative Current Forecast Amounts. Also, in an attempt to make the report more dynamic, I would want to incorporate more Variance Scenarios in the future. Such as showing Current Forecast/Current Budget/Prior Forecast/Actual - Prior Year then to the right show VB/VPF/VPY all comparing to Current Forecast. The solution above would only work for one scenario comparision at a time.