Date Restriction for slicer

[Anonymous]

Hi Users,

I'm learning power bi. I would like to restrict the slicer as below and the visuals should interactive. Please help in achive this. 

Thanks,.

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, you want to create a Slicer which contains dates between today() to today()-30, and use the Slicer to interact with other visuals, you can follow my steps:

1. Create a calculated table:

Date =

var _Calendar=CALENDAR(DATE(2020,1,1),DATE(2020,12,31))

var _today=FILTER(_Calendar,[Date]>=TODAY()-30&&[Date]<=TODAY())

return _today

2. Create a connection between the ‘Date’ table and your main table, like this(This is my test data):

3. Create a Slicer, place ‘Date’[Date] into the Silcer, like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@Anonymous , for date range it is not possible,

You need to have a slicer that can restrict days last that 30 days

You can have a column-like and try like this

Is Last 30 = if('Date'[Date]>=TODAY()-30 && 'Date'[Date]<=TODAY(),"Today",[Date]&"")