Date Filter report but want to show a visual for all the days that week

[DebbieE]

Hi 

We are setting up a report with all the visuals showing a specific days information

There is a slicer on the report for a date

However for one of the visuals, we would like to show everything for that week

Im guessing that I need to think about a dynamic table of dates (The week of the selected date) created from the slicer that could be used as a filter on that visual but at the moment Im not sure the best way to do it

[Fowmy · Accepted solution]

@DebbieE 

You can adopt the following approach for your scenario: 

https://www.youtube.com/watch?v=d8Rm7dwM6gc

[DebbieE]

there is a problem with this solution It would seem that the DAX DATEINPERIOD doesnt have week

DAY, MONTH, QUARTER, and YEAR

Is there anyway we can resole this to use this for current week (The video is for the 6 months around the date)

[DebbieE]

Fantastic. Thank you so much