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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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