Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer Issue in desktop

Hi all,   I currently have a slicer with dropdown dates. When I refresh the data, I need to manually change the date in slicer. How can I make it to refresh automatically?   As in the above...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Based on my testing, even after restricting the date in the slicer to show only the latest date, when the data is updated, the slicer retains the last selection. As shown below, showing both 3/15/2022 and 3/13/2022. 3/13/2022 only disappears when you manually select 3/15/2022.

 

                  

 

A workaround is to use measure rather than slicer to filter the latest date in other visuals.

 

Measure = 
COUNTROWS (
    FILTER (
        'Table',
        'Table'[Starttime] = MAXX ( ALL ( 'Table' ), 'Table'[Starttime] )
    )
)

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Winnie,

apologies for the late reply. I couldn't get the desired result from the above measure. My expectation is when the date slicer needs to get updated automatically once the data is refreshed. As of now I need to select it manually. I also need to retain older dates but the slicer should get updated automatically. The below data was refreshed on 29th, so I want the date slicer to automatically show to 29th instead I need to switch manually.

 

 

Thank you, 

AV