Forum Discussion

DiePic's avatar
DiePic
Resolver 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.