Gauge chart

[#1]

Time	Scenario	Revenue Dollars	Volume
Nov 2011	Actuals	$235,369	12354
Nov 2011	Budget	$215,027	13354
Dec 2011	Actuals	$7,567,546	17754
Dec 2011	Budget	$7,543,456	33354
Jan 2012	Actuals	$4,234,455	15454
Jan 2012	Budget	$4,543,456	78354

Hi,

Please help me build a gauge chart with the above table as an example. I want to build a gauge chart for each month for each metric( Revenue dollars, Volume) which will show the difference in the budget and actual vaues of each metric. If its positive it will point to green color , if negative it will point to red color.

I am using this expression but this does not help me calculate the correct differnce

sum({<Scenario={Budget}>}[Revenue Dollars]) - sum({<Scenario={Actuals}>}[Revenue Dollars])

With this expression it gives me some garbage value.

Please help me.

Thanks,

Shikha

[hic · Accepted solution]

You need quotes around the field values:

sum({<Scenario={'Budget'}>}[Revenue Dollars]) - sum({<Scenario={'Actuals'}>}[Revenue Dollars])

HIC

[#3]

Thanks a lot for the reply. It did work, but what if I want to show 3 segments in the gauge char(green, yellow, red) with a min and max value for each segment. I don't see an option to perform this in the properties.

For example in the table above I want to perform the below presentation in the gauge chart.

sum({<Scenario={'Budget'}>}[Revenue Dollars]) - sum({<Scenario={'Actuals'}>}[Revenue Dollars])is positive then pointgreen

sum({<Scenario={'Budget'}>}[Revenue Dollars]) - sum({<Scenario={'Actuals'}>}[Revenue Dollars]) is .05*sum({<Scenario={'Actuals'}>}[Revenue Dollars]) then point yellow

sum({<Scenario={'Budget'}>}[Revenue Dollars]) - sum({<Scenario={'Actuals'}>}[Revenue Dollars]) id negative then point red

Thanks,

Shikha