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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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