The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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