Filtering of date slicer

[Afiq_Danial]

Hi everyone,

I have a data which shows from 4 July 2004 till 31 July 2024

I encountered a problem. Right now, my date slicer shows from 4 July 2004 till 31 July 2024.

I want to make it in a way that it will only show the (today) - 14 days until 31 July 2024. Example, its 3rd february today. I want it to show 2 weeks before february meaning it will be 20 January till 31 July 2024. Is there way i can do this?

Thank you!

[Anonymous · Accepted solution]

Hi @Afiq_Danial ,

You can create a measure as the visual-level filter.

For example,

Measure = IF(MIN('Calendar'[Date])>=TODAY()-14,1)

Put this measure into it, and set up show items when the value is 1.

Add a filter to a report in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[danextian]

Hi @Afiq_Danial ,

In your Dates table (or whatever the name of the table that contains the date), create a calculated column to filter the slicer. Add the calculated column to the visual tile in the filter pane and set it to true.

datefilter = 
Dates[Date] >= TODAY()-14