Setting default values - datetime in slicer on Power BI report

[JRBBI]

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 this? Has anyone had any luck in achieving this?

Regards, JRB

[v-yalanwu-msft]

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.

[TomMartens]

Hey @JRBBI ,

no wonder that you struggled, it's simple not possible.

There is no way to provide a value that initializes the selection in a slicer.

There are some approaches that require additional effort like creating an additional column in your calendar table, that flags the "today" date, then you can use this column to select "today." Following this path requires that the calendar table will be refreshed each day, the report design needs additional slicers, etc.

Regards,

Tom  

[JRBBI]

Thanks Tom. I am glad that I am not the only one. This is really helpful to know and perhaps something Microsoft may look at going forward. Cheers.