Forum Discussion
Dial Gauge changing limit
Responsive ResidentHi Faris, you can create a measure to get the max selected value from whatever field you're using for your slicer.
You'll likely want to create a disconnected table that contains the values for your slicer range, e.g. if the user is selecting from 1-100 you could create a calculated table using the GenerateSeries function https://learn.microsoft.com/en-us/dax/generateseries-function
Then use the column from this table for your slicer and create a measure like:
Gauge Max = Max('Your Slicer Table'[Slicer Column])
Then assign this as the Max value for the gauge visual.
See also https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-slicer-numeric-range
I am using count in the current table there are no numbers. The guages are the counts of audits extracted from the table using a measure, So I am not able to set limit from the table but by the count function
