Date Filter -7 Days, +7 Days from Selected Date on Slicer

[Anonymous]

Hi Everyone,

I was thinking of creating a dashboard with previous (-7 days) and forward (+7 days) from the selected date on the slicer.

For example:

When a user selects a date on the slicer (17th August 2022), as such:

The table will display previous (-7 days) and forward (+7 days) from the selected date, as such:

May I know if there is a way to achieve this result in Power BI?

Thank you in advance.

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to achieve this is to have disconnected slicer table like the below, and add the measure into the Filters section.

Please check the below picture and the attached pbix file.

The measure is in the attached pbix file.

[Anonymous]

Thank you very much @Jihwan_Kim , the solution works for me very well.