Automatic filter dashboard

[Syndicate_Admin]

I tell you that in a dashboard, I have a filter of days of the week. The problem is that I must be changing it on a daily basis.

If I have the current date using a current, could the filter be made to change automatically in relation to my current?

Best regards

[Syndicate_Admin]

I have a problem, in the consultation, the day of the week (Monday-Tuesday-etc) is as text. Could you bring the current date as text, and make some kind of relationship to the query text? that way you filter what's in the current day.

[v-deddai1-msft]

Hi @Syndicate_Admin ,

Not getting clear from your description. Would you please explain it with some sample data?

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

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @Syndicate_Admin ,

Yes, you can . As mentioned by amitchandak, you create a new column based on today and other day of week. Put it in slicer and you can changethe filter by slicer.

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

Best Regards,

Dedmon Dai

[amitchandak]

@Syndicate_Admin , you have create a column like this and use

Assume 

Day of week  = format([Date], "dddd") 

Day of week type = if( weekday([Date] = weekday(today()), "Current WeekDay" , [Day of week])

Select current weekday and save the report

[Syndicate_Admin]

A question, in the filter shown above, applying this method will in the same way have available to select the other days of the week?