Forum Discussion

JRBBI's avatar
JRBBI
Frequent Visitor
4 years ago

Setting default values - datetime in slicer on Power BI report

G'Day Everyone, We have struggled to find a method to select the current date in a date time slicer on a Power BI report when the report is first opened. There does not appear to be a way to do thi...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, JRBBI ,

Here is a solution. You can create a calendar table and then create a new column based on the calendar table, as follows

1.create a calendar table（if you have, don't create a new)

Table = CALENDAR(DATE(2022,5,30),TODAY())

2.Then create a column.

slicer = IF([Date]=TODAY(),"Today",FORMAT([Date],"yyyy-mm-dd"))

3.add a slicer and select it to "Today"


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.