Filter Visual to get last 30 days and the next 7 days

[Khomotjo]

Hello everyone,

I have a visual that shows  performance on orders MTD , I want to also include orders in the system for the next 7 days. I have looked at the filtering options  but I cant find anything that will do what I want. Also this filter has to be automated, it should not require a person to put the dates in.

[johnt75 · Accepted solution]

Create a measure like

Date is visible =
VAR CurrentDate =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    IF ( CurrentDate >= TODAY () - 30 && CurrentDate <= TODAY () + 7, 1 )

Add that as a filter to the visual, set to only show when the value is 1.