Forum Discussion

asparagus1_'s avatar
asparagus1_
Helper I
11 months ago
Solved

Relative Date Filter Not Working?

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 fro...
Need Help
  • MasonMA's avatar
    MasonMA
    11 months ago

    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's avatar
pankajnamekar25
Super User
11 months ago

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