Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lfrazzoni
Frequent Visitor

Slicer Filter with daily date with current month as default

Hi all,

 

I would like to give to my users a daily date filter (with slicer) where they can choose different intervals:

lfrazzoni_0-1678458243362.png

 

Is possible to put (in the same slicer) a default dynamic value that shows the days of the current month?
For example, today 10th March 2023, I open the report and see this:

lfrazzoni_1-1678458359025.png

 

Of course everyday I've got new data with day granularity, so the filter has to change default everyday.

Thanks

5 REPLIES 5
Ahmedx
Super User
Super User

and this solution is right for youScreen Capture #495.pngScreen Capture #496.png

I'm sorry but I don't understand. 

In both your answer I see the filter with all dates of this year.

I need a dynamic default value, with all the days of "current month", but the user could be able to change this interval (for example 1/2/23-15/2/23).
If you add a filter on the visual, the user can't change the "current month" interval, am I wrong?

it's impossible

 

lfrazzoni
Frequent Visitor

Hi @Ahmedx ,

thanks for your reply.

In this way my users has to remove the filter on "Filter Section" before changing intervals from the slicers.

 

I also already tested the solution with two filters on canvas (Current Month: Yes/No and Slicer Daily Date), but I'm curious to know if there is a solutions with a single filter.

 

Thanks again

 

Thanks

Ahmedx
Super User
Super User

Screen Capture #493.pngScreen Capture #492.pngScreen Capture #494.png

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors