Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Slicer Relative Date Issue From and To..

This is bugging me....

I have a slicer based on a Date Field in a Table..

On the Filter on this Visual i have it set to Realtive Date is in the next 1 day, not including today. So it should default to Today + 1.

 

On the slicer itself I am finding the TO date is adhering to the filter but then FROM date is staying on the last date it was used / refreshed.

I need a slicer as the report although default is tommorow it is also used to report on a range of dates, which the user can select. 

It  must be something easy but as yet not found the trick yet.

 

This is what I am seeing on intial load up, unless the user spots it they can be looking at the wrong data...

 

 

Cheers in anticipation.

 

Andy

 

Need Help

2 Replies

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

    Anonymous , These visual level filters might not work with range slicers.  - Log an issue if needed.

     

    I usually create a new column and use that slicer and save it on tomorrow or today

    Date Type =
    SWITCH(TRUE(),
    'Date'[Date] = TODAY(), "Today",
    'Date'[Date] = TODAY() -1 , "Yesterday",
    'Date'[Date] = TODAY() +1 , "Tomorrow",
    [Date]& "")

     

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    According to your description, I can roughly understand your requirement, I think you can create another calculated column to be placed in the date slicer like this:

    Date in slicer =

IF([Date]=TODAY()+1,"Tomorrow",FORMAT([Date],"yyyy-mm-dd"))

     

    And you can roughly get what you want.

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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