Dhruv Mevada
Dhruv Mevada

Reputation: 11

Set default date as last 7 days from present date in date slicer Power BI

I have date slicer which coming from 'date' column contains date from 1-1-2017 to present date. Currently date slicer shows min and max date but I want to set default date as last 7 days from present.

I want to show the default from/to date as last 7 days from present day like this.

1

Constraints

2

Upvotes: 1

Views: 2302

Answers (1)

MarcoPrk
MarcoPrk

Reputation: 11

Select your slicer, then go to the filters pane, select Date, and choose relative date. This way you should be able to set the filter to the last "x" days.

Upvotes: 1

Related Questions