Forum Discussion
Date slicer default values
Hi, I have date slicer (between) in my report and I would like to set "To date" to todays date and "From date" to first day of current month everytime when user opens that report. Is this possible i...
Hi, strn1k
You can try the following methods.
Measure =
Var _date1=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
Var _date2=TODAY()
RETURN
IF(SELECTEDVALUE('Date'[Date])>=_date1&&SELECTEDVALUE('Date'[Date])<=_date2,1,0)
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, this is very great, thanks for the answer.
But there is still one huge issue, the date filter now has the date range that I want but it is not applied to the visualizations :(.
So users have to "confirm" (click to filter and click to both dates) to apply this filter to visualizations and it is very undesirable.Hi Anonymous , do you know why the filter is not applied?
