Configure Date slicer based on latest DAY (also a slicer)

[Anonymous]

Hi
I have a requirement where i have two slicers
1. Day
2. Date
Firstly, When user select Mon in the Day Slicer, the Date slicer must display dates only for Monday.
Secondly, as per the current day the DAY SLICER value must get updated i.e. if user opens the dashboard on Tuesday - DAY = tue & Date = all values for tuesday
Thirdly, do not want user to manually select or update the day / dates.

Thanks
Stuti

[amitchandak]

You have Visual level, page-level filter pane in a new version. If you drag a date there you will get a relative and advance date option. That can give date like today, yesterday, etc..

[Anonymous]

Yes but Relative Filtering sets a limit around date i.e. if user wants to view datapoints beyond 30 days / 3 weeks it will not be possible.

[v-xuding-msft]

Hi @Anonymous ,

Do you implement the requirement? If so, would you mind marking helpful or prefer replies as answers? You could share your own answer. And more people will benefit here. 

Best Regards,

Xue Ding

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

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

1. If Day and Date are from the same table, or there are the relationships among the tables, it will be filtered automatically when you select the slicer of Day.
2. It is impossible to update DAY SLICER based on the current day.  And we couldn't implement that the reports or dashboard will be filtered by today automatically. Users still need to select the slicer to filter them.
3. Currently, we still need to filter manually. You could create a calculated column as a slicer to filter the data of today.

TODAY = IF('CALENDAR'[Date] = TODAY(), TODAY(),BLANK())

Best Regards,

Xue Ding

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