Slicer Issue in desktop

[Anonymous]

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 image I need the slicer to automaticaaly update to 15th without manually changing it. Any suggestions would be soo helpful.

Thanks,

AV

[v-kkf-msft]

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]

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

[amitchandak]

@Anonymous , You need to create a static column like this and save or today or yesterday

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"2 Days Ago"
,'Date'[Date]&"")

As of now only this work around is there