Filter chart based on today's day number

[Anonymous]

Hello PBI users,

I am currently trying to display a graph filtered by today's day (monday to sunday).

I already have a column with the day name and day number in my table. However, when I want to filter my chart with these columns, I need to select a specified day (for example day number from 1 to 7)... and I would like it to be today's (all mondays filtered in my table if today is monday for example).

Any idea how to implement this feature please ?

Regards,

Antoine

[amitchandak · Accepted solution]

@Anonymous 

Assuming using a day table an that has a weekday or use weekday also in filter

Measure =
Var _max = weekday(maxx(allselected(Date),Date[date])) // Or take today
return
calculate([Value Measure], filter(all(Date),Date[Weekday] =_max))