Relative Date Filter Not Working?

[asparagus1_]

Hi everyone,

I'm having trouble with a relative date filter in Power BI. I applied a "Relative date" filter to show only the last 180 days (including today), and all the fields in my visual come from the same Date table. Specifically:

• The visual uses a Year-Month column from the Date table.
• The filter is applied to the Date column from the same table.
• The Date column is of type Date, and Year-Month is a formatted column.

Despite this setup, the visual still shows all available dates, not just the last 180 days.

How should I adjust it?

[MasonMA · Accepted solution]

@asparagus1_ 

It looks you are using visual-level filter only on Slicer. Try using page-level or report-level filter instead. 

Also, you may test with 'Select All' disabled, 'Select All' basically is equivalent to applying no filter at all on that field (because everything is included). So if your slicer is on Date[Year-Month], and you have "Select All" checked, then your visual is seeing the entire set of dates, unless another filter (like a relative date filter) is applied on the underlying Date column.

[pankajnamekar25]

Hello @asparagus1_ 

Try these optionsUse the  date column in the visual and format it as mmm-yyyy.Apply the filter at page/report level instead of only at the visual.Create a DAX flag column (e.g., last180daysfalg) or a measure to restrict data to the last 180 days.Ensure proper relationships between fact tables and the Date table.

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn