want to set slicer default to last 30 days

[Anonymous]

Hi,

I am using a union function to create a custom filter. and sync them between slicers with it so I can create a bookmark and use them in a bookmark manner. For reference

when I am using last 30 or 90 days I am unable to get the date before that date(Its getting inactive). How can I make them active in the same form.

can you help me out with this.

[bolfri]

Hi,

You have this one inactive because you are using "Last 7 days" filters from TODAY(). Can you describle how you wanted this to work? Did you mean "Last 7 days" from your max selected date? 🙂

[Anonymous]

Hi,

Got your point, as I am using the max-min function the between slicer is not showing the other values.

Now can you help me out if I am selecting the last 7 days from the drop down slicer the data should be for last 7 days and in between slicer it should show the date range of last 7days but other dates should not be inactive it should work .

[Anonymous]

Hi,

If I am selecting the last 7 days it should show the same but when I am switching to between date slicers it should show the same last 7 days' data with this, I would be able to select a different date range to filter.
Currently its showing only last 7 days in the between slicer and rest dates are inactive. So it shoud not be inactive in the between filter

[bolfri]

But Last 7 days from TODAY() always be 7 SAME DAYS. You can't change the result of today by clicking different day into the calendar slicer ^.^ I think you need to rebuild this solution to create a measure that checks if the date is in the last 7 days calculated from last selected date on slicer, not from TODAY() function, so you can't do it into table calculation like you did. 🙂

Can you share a sample pbix file to help you with example?

[Anonymous]

Hi, sharing the pbix with you.

https://github.com/mustafaasiroglu/sampledata/blob/master/Special%20Range%20Date%20Slicer%20with%20D...

[amitchandak]

@Anonymous , Disable interaction between the slicer and date and try

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[Anonymous]

Tried this the slicers are already in sync if I am using edit interaction it's messing up all the things