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

 

Thanks,

AV

Need Help

3 Replies

  • 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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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