How to Create Predefined Date Filters in Power BI Without Manual Slicer Adjustments?

[manoj_0911]

How to Create Predefined Date Filters in Power BI Without Manual Slicer Adjustments?

Hello Power BI Community,

I would like to create a set of predefined date filters in Power BI, such as:

- "Today"
- "Yesterday"
- "This Week"
- "Last Week"
- "This Month"
- "Last Month"
- "This Quarter"
- "Last Quarter"
- "This Year"
- "Last Year"
- "Custom Range"

My goal is for users to easily select one of these predefined date ranges from a slicer or dropdown, without having to manually adjust the date slicer for each report view.

I want to avoid manual date selection in a date slicer and instead provide these preset options for quick filtering. Additionally, I'd like to have a "Custom Range" option where users can manually select dates if needed.

What is the best way to implement this in Power BI?

Thank you for your support!

[danextian · Accepted solution]

Hi @manoj_0911 ,

You need to get the start and end dates for each period type  and then generate rows of dates using that information. Also, I don't see a difference between all time and custom. If custom,  ill just show all dates and let user select a range from a slider which can me it is either custom or all time. The generated rows of dates are t hen related to the actual dates table. You can use a measure as well to filter a visual but you'll need to reference this measure in other measures if the dates are not included in a viz. Please see attached pbix.