Forum Discussion
Gauge Chart Dynamic Maximum Value
Hi all, I am trying to create a gauge chart with a dynamic maximum value based on the slicer filters (Category & Query & Date Range) on the dashboard. I am in the marketing industry and am trying t...
Hi tamerj1
I got it to work!! Thank you so so much for helping me out!Current CTR (Gauge) = CALCULATE( [Avg CTR], FILTER( 'GSC query analysis', RELATED('Calendar Lookup'[Start of Month]) = MAXX('Calendar Lookup', 'Calendar Lookup'[Start of Month]) ) )
