Date slicer to override filter

[kitti]

Hi,

I have a dashboard to show last 7-day data for the entire page by default. I configured it on the page level filter. But there is a range date slicer allowing users to select the date themselves. Currently, they can only select last 7-day data as I configured. Is there a way to select date more than 7 days but still show 7 days as default?

Thank you

KL

[Anonymous]

Hi  @kitti ,

I created some data:

You can try the following methods:

Place two visuals related to the date, one visual is affected by its own filter and the other is affected by the slicer.

1. Click on visual2, set is in the last - 7 - days in Filters, and visual2 will display the data of the last 7 days.

2. Click on the slicer, select Format - Edit Interactions - Visual in the upper right corner of the sign (yellow mark), so that visual2 will not be affected by the slicer.

3. Result.

When the slicer is selected, the content of visual1 will change with the selection, and visual2 will not be affected by the slicer, and the content of the filter is displayed.

Best Regards,

Liu Yang

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

[kitti]

@Anonymous  Thank you very much for the method. However, I want the entire page go with the slicer. Just show last 7 days as default at first when users view. Could you please advise

[amitchandak]

@kitti , You can create a slicer like this or use.

Date Type = SWITCH(TRUE(),'Date'[Date]<=TODAY() && 'Date'[Date]>=TODAY() -7,"Last 7 days"
,'Date'[Date]&"")

Or you can measure to work on last 7 days using date

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

[kitti]

@amitchandak Thank you for the comment. I just tried the slicer but it shows up only last 7 days. Just FYI, my data in the dashboard is around 90 days. I want users to be able to select as far as my data is. I really appreciate any help