Forum Discussion
Slicer Single Select is defaulting a value
I have turned on "Single Select" for my YYYYMM slicer. The issue is, it is defaulting to the first available value, so I have sorted it descending and published the model. When published, the default...
Thanks Anonymous You probably didn't get full context of my question or I am not following about using bookmarks. The values I need every month doesn't exist, for example 2019-07 will not be part of data set until we are in July 1st 2019. If I defaults it to 2019-06 today, How do I use bookmarks to default the slicer to the new value (2019-07)? I understood that this is not possible, please confirm again.
HI deepu299 ,
Please write a measure with today function to compare current row contents and return flag, you can use this measure on visual level filter and save as bookmark.
This measure who save to bookmarks will changes if data model refreshed.
Regards,
Xiaoxin Sheng