Forum Discussion
Resolver IISet 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?
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.
3 Replies
- adudani
Memorable Member
hi DiePic ,
some references:
1.3 Insanely Awesome Slicer Tricks in Power BI 🤯 ( Change the current month formula to TODAY() else provide the value of the date column ) Alternatively,
2. Default Current Month Slicer in Power BI - How to default to the current monthif this doesn't resolve the issue, kindly provide a sample input with masked data and a sample output.
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
