Help Creating Custom Date Slicer with Multiple Options in Power BI

[manoj_0911]

Hi everyone,

I'm working on a Power BI report with contact center data (MS SQL Server database). I've created a report with durations (available, on queue, etc.) and other details.

My Goal:

I want to create a custom date slicer similar to the approaches shown in these resources:

• YouTube video: https://www.youtube.com/watch?v=8pDjbzNz1g8
• Blog post: https://www.youtube.com/watch?v=fKygF7VEJnQ

What I've Done:

• I successfully replicated the basic custom date slicer functionality with my data.
• I duplicated the date field and converted it to a separate date-only field.

Attachment:

https://drive.google.com/file/d/1QH416a-Z3IwH_TRWbGc0C2Vjoaa--mF_/view?usp=sharing

https://drive.google.com/file/d/1HYw0DC5s56FOiAW3is0XGJ1f0_LGby7s/view?usp=sharing

https://docs.google.com/spreadsheets/d/1d27HTjHokUp8mfzh0JnCWleoySD5Kt1w/edit?usp=sharing&ouid=10765...

Further Requirements:

I'd like to expand the custom date slicer options beyond a single date selection to include pre-defined periods like:

• Today
• Yesterday
• This Week
• Last Week
• This Month
• Last Month
• This Quarter
• Last Quarter
• This Year
• Last Year
• Custom (user-defined date range)

Request:

Any guidance on achieving these additional date range options within the custom slicer would be greatly appreciated. I've attached my sample data and Power BI file for reference.

[Anonymous · Accepted solution]

Hi, @manoj_0911 

If you want to achieve a dynamic change in data, you need to avoid using Calculate Column, but you can't filter Between-type slicers after using Measure, which is by design. In the video you gave, you can also see that the Youtuber does not use the Between type of Slicer, the following is my method (I can't change the date range of the Between type Slicer at will), I hope it will help you.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum