Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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])
    )
)

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I actually have tried this line of code before. It showed correctly in the matrix, but incorrect in the gauge chart.

 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

For some reason, no matter what we do ot only shows the value of the last date! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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])
    )
)

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Now you mentioned that it always show the last date, I realized it is because I set the visual filter to be "Start of Month" - "Top 1" - "Latest Start of Month" so that I can show the current CTR (0.07), but then it will cause the Max CTR to not work. 

    If I clear that fitler, the Max CTR will be correct! but then the current CTR will be incorrect.

    That being said, we can tackle it from a different direction, trying to create a new measure to get the current CTR for the gauge chart. Do you know how I can write the code to get the current CTR for the gauge chart?