Forum Discussion
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...
TomMartens
Super User
Super UserHey 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
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.