Forum Discussion

Nibz's avatar
Nibz
Icon for Helper I rankHelper I
8 years ago

Slicer last day

Hello,   I have a timeline slicer based on the last day, but users can select 7 days before I would like each day the slicer is in the last day.   When a user enter in the report, it is on the l...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Nibz,

Please use the DAX below instead, then create a slicer using this column and set its value to 1.

Yesterday= IF( Reservation[Start] = TODAY() - 1, 1, 0)


Regards,
Lydia

Nibz's avatar
Nibz
Icon for Helper I rankHelper I
8 years ago

I am sorry, it is still not goof for me.

 

The new column is ok but it is not possible to select the 1.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Nibz,

    Please make sure that your date column contains the yesterday's date, otherwise you would only get 0 in the calculated colum.

    Regards,
    Lydia

    • Nibz's avatar
      Nibz
      Icon for Helper I rankHelper I
      8 years ago

      Yes I am sure

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Nibz,

        I am not able to reproduce your issue in my Desktop, would you please share the data of the Date column for me to test?

        Regards,
        Lydia