Howto select all available dates to a date slicer

[VVR]

Hi,
How can we select all available dates to a date slicer (Slicer setting styles between and before) so that all available dates are selected by default also after the underlying data is updated in a scheduled refresh of dataset and the date range has widened?

I have all available dates in a dynamical table

myCalendar = CALENDAR(MIN(myDatatable[date]), Max(myDatatable[date]))

and have inserted them into date slicer. When the application is published all the available dates are selected. This approach has worked couple of years but now when I publish new versions to PBI server the slicers aren’t updating any more to the maximum available range after the scheduled datarefesh. Previously published versions (2022) on Power BI server are still working but if I publish eg. exactly same program version again to the PBI server application is not behaving similarly anymore. Has something changed in the latest 12/2022 release?
BR, VVR

[amitchandak · Accepted solution]

@VVR , It should update.

I usually prefer calendarauto

myCalendar = calendarauto()

[VVR · Accepted solution]

Thanks for your reply. Works now as expected. One have to clear all selections through visual header. "Clear selection" property was misfortunately hidden by disabling header section and due to too small size of the slicer. If minimum and maximum values are at some point adjusted with date bar then values are ultimately bolted even if they are outermost ones at the time of publication. My mistake.

[amitchandak · Accepted solution]

@VVR , It should update.

I usually prefer calendarauto

myCalendar = calendarauto()