Is it possible to dynamic Min, Max, Targets on gauge visual with RLS

[megachuckmc721]

I'm wondering if it is possible to somehow dynamically set the Min, Max, and Target values on the Gauge axis in conjunction with RLS?

Example:

With the gauge visual...If I have 15 different users who all have different sales, call,etc. quotas I can use RLS to limit the Callout Value that each user sees on the dashboard, but I can only set a single value for the Min, Max, and Target variables on the gauge visual.  

Min = 0, Max = 360 and Target = 180 might be okay for user 1 but user 2 might have 

Min = 0, Max = 280 and Target = 140

Any thoughts on this greatly appreciated!

Mike

[v-huizhn-msft]

Hi @megachuckmc721,

You got any idea from the reply? Or you have resolved your issue by yourself? Please mark the right/helpful reply as answer, more members like you will benefit from here.

Best Regards,
Angelia

[Anonymous]

Hi @megachuckmc721,

Maybe you could realise it like this:

Slicer with the column [User] as value

and measures like

MIN(Table1[Sales])

MAX(Table1[Sales])

you put the measures in the min and max and target in target, so that way when someone clicks his own name. The measures will dynamically calculate his MIN and MAX and target gets filtered on User so that will be correct too when a User is selected through the slicer.

If this is'nt possible or does'nt work, can you share your data model with dummy data then please ?

Regards,

L.Meijdam