Gauge chart help

Question

Hi all!I am working with gauge chart but I am facing an issue.I am compraing budget against actual for projects in some regions. However, for some projects I just have the budget, since they didnt start yet, and I have no data in actual for them.Gauge chart cant show the target (that is a measure) for the projects that didnt start. So, when I am analyzing the whole region, the gauge chart is bringing an incorrect budget, since is not summing the budget for projects that didnt start yet.Do you mind how I can fix this?&nbsp;Thanks!

v-chuncz-msft · Answer

Anonymous&nbsp;
&nbsp;
The requirement is not very clear.&nbsp;You may add&nbsp;zero (+ 0) to the DAX formula or specify a default value if necessary.

anonymous · Answer

Hi&nbsp;v-chuncz-msft&nbsp;I didn't get your solution.Let me try again... Please, consider table below.&nbsp;ProjectBudgetActualTargetMax ValueA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 580&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,300B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,600C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,350&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,900D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,200E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,500Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,630&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19,500&nbsp;The budget has figures for many projects, however the actual no, since some projects didnt start yet. Gauge chart should show the Target value as 15,000 but once there is no value for actual, it is showing 8,000 because it not summing projects B and E.&nbsp;This is what I need to fix. Show the correct target of 15,000.

thomassts · Answer

If I understand well, you coded your target as the sum of all individual project targets?Easiest solution is to hard code a single target value -&gt; separate column

anonymous · Answer

Yes,&nbsp;ThomasSTS&nbsp;As I am using slicers, I can checking just one project or all projects of one region. For one project, the chart is right, however for the region is not. The region is the sum of all projects in this region.

Forum Discussion

Gauge chart help

4 Replies

Related content

Gauge chart

Gauge chart

Gauge Visual

Gauge Chart Colour Formatting From Measure

color in gauge chart

Project	Budget	Actual	Target	Max Value
A	1,000	580	1,000	1,300
B	2,000		2,000	2,600
C	3,000	1,350	3,000	3,900
D	4,000	2,700	4,000	5,200
E	5,000		5,000	6,500
Total	15,000	4,630	15,000	19,500