Hello,
I had an issue that can't figure out how to control the gauge chart color limitation and pointer movement.
I want to show the sales vs Quota use the Gauge chart and I set the Min/Max limit with the expression.
Also, I set the Range limit use segments according the % of the Quota to present different color less than 85%, 85%--100%,
100% and more three ranges and set the reference numbers for the 85% Quota and Target Quota.
The Issue is that when I applied the filter to each Gauge chart for different Account Manager or Territory, the Color limit and pointer moved at synchronized way, which I want only the pointer move to the target number, and the color limit stay the stable position.
Any suggestion and advice will be much appreciated!!