Forum Discussion

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
1 year ago
Solved

Set date opening the report page

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?
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
DiePic
Icon for Resolver II rankResolver II
1 year ago

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