cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deepu299 Member
Member

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 value was 201902. When new months are available, I presumed that the selection will be still defaulting to first value which I thought will be 201903 and after a months it will be 201904. But this is not happening. The slicer selection is always showing 201902. 

 

Is there a way to have the slicer select the newest value? I am also Ok having it with No Selection. 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Slicer Single Select is defaulting a value

Hi @deepu299 ,

AFAIK, power bi not support to setting default value of slicer.

For single selection mode, it will force to choose first one as current selection. I haven't found any option not setting default value and make it dynamic. Maybe you can consider to set up bookmark to control default selections items.

Use bookmarks to share insights and build stories in Power BI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
deepu299 Member
Member

Re: Slicer Single Select is defaulting a value

Thanks @v-shex-msft  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.


Highlighted
Community Support Team
Community Support Team

Re: Slicer Single Select is defaulting a value

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 173 members 2,562 guests
Please welcome our newest community members: