Forum Discussion
Gauge chart help
I didn't get your solution.
Let me try again... Please, consider table below.
| 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 |
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.
This is what I need to fix. Show the correct target of 15,000.
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 -> separate column
Yes, ThomasSTS
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.