Urgent Request: Variance Reporting

[JadenWelch]

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 & Expense, which are both calculated metrics. However, I have enabled the feature to switch values to rows.

The "Scenario" field has 2 values: "Current Forecast" and "Current Budget".

Currently, the end result of the matrix visually looks like this: It has Two columns called Current Forecast & Current Budget. It lists all the industries as Rows, and under each industry, are two rows for Revenue and Delivery Expense related to that Industry.

I want to adjust my matrix to be able to visually have a third column showing Variance to Budget, where it subtracts the Scenario field from each other (Current Budget from the Current Forecast). I want to leave my existing values as rows.

My end result should visually look like this:

It has Three columns called Current Forecast & Current Budget & Variance to Budget. It lists all the industries as Rows, and under each industry, are two rows for Revenue and Delivery Expense related to that Industry.

Attached is a picture of sample data, along with what it currently looks like. I've also shown an image from excel of what I need. 

[Slim-]

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]

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.