Forum Discussion

Vahks's avatar
Vahks
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamic Max Jauge with slicer date

Hello,

I am trying to create a gauge with a dynamic maximum, which can only be influenced by a date slicer, I do not want my other Nature Slicer that you will see in my example below to be able to influence the maximum.

I am attaching an example : Here 

 

I tried several formulas but it didn't work.


Someone can help me please ?

Thanks

Need Help

4 Replies

    • Vahks's avatar
      Vahks
      Icon for Helper I rankHelper I
      2 years ago

      Hi Turn off interactions doesn't work because i don't need to fix the value, only the max value of the gauge when i click on the other filter.

       

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Vahks ,

    Have you solved your problem?
    If not, please try this way.
    Use this column to build a new table without any relationships:

    Use this DAX to create a measure in the new table I build just now and put it into the Maximun value of the Gauge:

    Test1 = 
CALCULATE(COUNT('Slicer'[Created_At]), FILTER('Slicer', 'Slicer'[Created_At] >= MIN('Calendar'[Dates]) && 'Slicer'[Created_At] <= MAX('Calendar'[Dates]) ))

    The final output is as below:


     

     Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.