Forum Discussion

Nibz's avatar
Nibz
Helper 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
Helper 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.