How to Use a table of Target Values for Filtered Gauge Charts

[Anonymous]

I have a table of target values updated based on management decisions and would like to use that for the target values in a gauge chart to look at all the metrics for a single client. When I filter the visual based on client the target value disappears. How do I fix this? 

Using formatting to manually insert "2" I get what I want, but I want to be able to regularly quickly update the targets for a large number of gauges.

Clients

Person	Complaints	Days Late	Form Errors
Angel Saint	0	0	0
Damian Demon	50	100	200
Joe Normal	2	1	10

Targets:

Complaints	Days Late	Form Errors
2	1	10

Using the value from the Targets table I get this: 

Using formatting to manually insert "2" I get what I want, but I want to be able to regularly quickly update the targets for a large number of gauges.

[v-stephen-msft]

Hi @Anonymous ,

Do you want to display your Complaints, Days Late, Form Errors in a gauge visual?

It sounds difficult, but you can try tooltips. When you hover over a data point, other field data related to it is displayed.

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[Anonymous]

No, that wasn't my question. I want to have a series of gauge visuals for each variable. My problem is that the target variable marker disappears when I filter the data if I do not hard code it in the formatting. I would like to use my table of target values as the data of the targets. (The first image shows the error, and the second shows what I want.)