Forum Discussion

Victormar's avatar
Victormar
Helper V
2 years ago

Personalized date filter

Hello community,   I have a report where I have visualizations based on the sending date for the data. This data belongs to vehicles, and they also have a contract start date, and a latest sending ...
Need Help
isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

Hi Victormar,

 

Please consider below measure and add it into the visual level filter. Thanks.

Start from Contract Start Date = 
IF( CALCULATE(MIN('Table'[Contract Start Date])) < SELECTEDVALUE('Table'[Sent Date]),1,0)

 

Best Regards,

Joyce 

 

  • Victormar's avatar
    Victormar
    Helper V
    2 years ago

    Thanks for your help. I tried it but the visual doesn't change, it's always the same. Could it be that the filters are not made to dynamically change?

    • isjoycewang's avatar
      isjoycewang
      Solution Supplier
      2 years ago

      It should be able to change. Please share some dummy data and your chart so we could have more information, thanks!