Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
Hi all,
I would like to give to my users a daily date filter (with slicer) where they can choose different intervals:
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:
Of course everyday I've got new data with day granularity, so the filter has to change default everyday.
Thanks
and this solution is right for you
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
55 | |
37 | |
31 |
User | Count |
---|---|
83 | |
64 | |
63 | |
49 | |
45 |