Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
@VVR , It should update.
I usually prefer calendarauto
myCalendar = calendarauto()
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.
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.
@VVR , It should update.
I usually prefer calendarauto
myCalendar = calendarauto()
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
83 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
108 | |
64 | |
60 |