Forum Discussion

kxj's avatar
kxj
Frequent Visitor
3 years ago
Solved

Between Date Slicer with Relative Date Visual Filter not affecting table

Hi. I have a between slicer that should be defaulted to show YTD records. I've set up the Slicer to use the "Between" display and have a relative date visual filter on the slicer to show everything i...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi kxj ,

     

    In myside, I can reproduce your issue. When I set a relative date filter on my between slicer, my table visual will still show all values.

    As far as I know, this should be caused that there is no selection in slicer so Power BI will not set the new start date and end date to your table visual. Here I suggest you to use the two sliders in the between slicer. This will activate the between slicer. 

    Or you can use the relative date filter on your table visual as well.

     

    Best Regards,
    Rico Zhou

     

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

     

amitchandak's avatar
amitchandak
Super User
3 years ago

kxj , As of now Range slicer do not default well based on filter from other slcier.

 

We usually create a column like

If([Date]<= Today() && [Date]>= (eomonth(Today(), -1* month(Today())) +1), "YTD" , "Other")

 

and save it on YTD

 

You can log an idea : https://ideas.powerbi.com/ideas/