Gauge with dynamic target

[sawn]

Hello, kindly assist in showing how to create a dynamic gauge target based on a slicer. I have data on New water points to be constructed per State as well as the number of water points to be rehabilitated per state. I would like to show the achievement of each based on the target provided when the new or rehabilitated slicer is selected and not to show the total for both as the target.

State	New Water Points	Rehabilitated Water Points
A	7	3
B	30	10
C	8	2

I would want the target (currently showing 60) to change based on the slicer selected whether new or rehabilitated

Thank you

[v-zhangti]

Hi, @sawn 

You may need to provide more details. Can you provide photos of the source data? How was the number of sites identified calculated? Where did the 26 in the figure come from? If you can, please give an example and let me know what you expect the output to be. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sawn , check if you can use what if parameter for that

https://docs.microsoft.com/en-us/power-bi/desktop-what-if