Specific Number of Days in a Page Level Filter

[Spudduk]

Quick one, which is doing my head in....

How do I create a page filter to only looks at Todays date + 2... 

In the relatve filter its either pulling in today or Today +1 and Today +2.  I only want to see Today +2. Was hoping to get away with 

Have created a measure but can't apply to this to the page filter.

Cheers 

Andy

[v-yueyunzh-msft · Accepted solution]

Hi , @Spudduk 

According to your description, you want to filter the Today+n data in the visual .

Here are the steps you can refer to :

(1)This is my test data:

(2)We can create a what-if parameter as a slicer :

(3) Then we can create a measure :

Measure = var _slicer =[Parameter Value]
var _date =TODAY()+_slicer
return
CALCULATE( SUM('Table'[Value]) , KEEPFILTERS( 'Table'[Date] = _date))

(4)Then we put the fields we need on the visual and we can meet your need :

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[djurecicK2]

Hi @Spudduk ,

 Assuming you are using a date table called"Dates", create a calculated column called

IsTodayPlus2 = IF(Dates[Date]= (TODAY() + 2),True, False)

Then set your filter to IsTodayPlus2 is true.

Please accept as solution if this answers the question- thanks!