Set date opening the report page

[DiePic]

Hi all,
I have read a lot of posts, but nothing help my need.
I need set today on the slicer of my dates selection, when I open the report page ... is this possible?

[Anonymous · Accepted solution]

Hi @DiePic ,
Thank you @adudani  for the helpful response!

Please find the dax below:
DateTable =
ADDCOLUMNS(
CALENDAR(DATE(2024,1,1), DATE(2025,12,31)),
"Year", YEAR([Date]),
"Month", FORMAT([Date], "MMMM"),
"IsToday", IF([Date] = TODAY(), 1, 0)
)

Add a slicer with DateTable[Date] on your report page.Change slicer type to Relative. Refer the screenshots and the file attached  below:

If this solution meets your requirement,consider accept it as solution.

Thank you for being a part of Microsoft Fabric Community Forum!

Regards,
Pallavi.

[DiePic]

Thanks for reply @Anonymous ,
this is helpful for my PBI .... a

...
With your suggestion, a filter and 2 bookmarks I've solved my problem.
Thanks a lot @Anonymous 

[adudani]

hi @DiePic ,

some references: 
1.3 Insanely Awesome Slicer Tricks in Power BI 🤯  ( Change the current month formula to TODAY() else ...
2. Default Current Month Slicer in Power BI - How to default to the current month

if this doesn't resolve the issue, kindly provide a sample input with masked data and a sample output.