Dynamic Gauge: Fetch target from table

[MB17]

Hi all, apologies if this question has been asked before, but I've not been able to apply any solution I've found.

I'd like a gauge with a target value that varies by the slicers I've created: month and store.

I thought the easiest way would be to create a table with entries for each store, for each month, and use the target column for the visual.

Store	Month	Target
Store 1	1	10
Store 1	2	12
Store 2	1	35
Store 2	2	32

However, this does not generate the desired result.

Is this a viable approach in the first place?

[barritown]

Hi @MB17,

I am not sure what kind of result you expect, but your approach should work: the "single select" option must be enabled for your slicers, then you can you Min of Target, Max of Target or even Sum of Target.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian