Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Filter using measure

Hi All, My source is excel and the data is number of items (count) for each day. I have the counts on a score card. Since it is bringing sum of all the days i added a date filter and choose the late...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    1. Mark the largest date.

    2. Set the maximum date as the default value.

     

    Each time the date column is updated, the slicer will select the maximum date by default.

    The same is true for the solutions provided by amitchandak, DataZoe 

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

1. Mark the largest date.

2. Set the maximum date as the default value.

 

Each time the date column is updated, the slicer will select the maximum date by default.

The same is true for the solutions provided by amitchandak, DataZoe 

 

Best regards,
Lionel Chen

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