Date Slicer - Default value

[nranito]

I have a dashboard with a Slicer, which contains a date field. The slicer is configured as Between.

The dashbboard is refreshed every day.

I would like the slicer, each day, to have the interval Today and Today - 10 days (for example).

Of course, the slicer must continue to be edited.

Can this be acomplished?

Thank you for any help

[Neojate]

Nobody has a solution?

[nranito · Accepted solution]

Basically I want this:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19055692-slicer-default-selected-...

[Anonymous]

Did you find a solution ? I am now trying to do the same thing . 

Would be very helpful if you could share your solution . 

Thank you in advance !

[Anonymous]

@Anonymous : did you find the solution i am also doing the same

[v-yuta-msft]

Hi nranito ,

So your requirement is to create a dynamic calculate date column between today and 10 days previous, then create a slicer chart based on the column, right? If it is, I'm afraid power bi doesn't support dynamic calculate column. In addtion, you can submit your  idea about improvement of slicer chart here: https://ideas.powerbi.com.

Regards,

Jimmy Tao

[nranito]

I have a table with dates.

Let's say a year

My slicer must choose an interval inside that year

What I want is to be started with a default value (interval)

[jthomson]

One approach might be to make a custom calendar table that pulls today's date as the end point and today's date -10 as the start point and then relate that to your main calendar?

[nranito]

But can I still change the calendar like that?

Because I want those as default, but still want to maintain chance of choosing any random dates outside that range

[jthomson]

Ah, I see what you mean now, that's not going to work for what you want