cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
semsel
Frequent Visitor

Single Select Horizontal Slicers without a default Value

I have 2 horizontal Slicers that are connected to each other Page Category and Page Name which helps users to navigate to the rest of pages with a Go To Arrow button. I have to keep the slicers as Single Select as otherwise Page Navigation doesnt work.

 

I want to keep a default display like below so that users still see all available options. I could only achieve this view only with a multi select Slicer.

semsel_0-1624540743744.png

But the moment  I make any of the slicers Single Select in Power BI Desktop, it becomes like below since the first value is defaulted as I understand. This view is preventing  the user from accessing other options.How Can I achieve the first image same time using Single Select slicers? I have tried Bookmarks as suggested in many pages but didnt help as defaulting cannot be suppressed in any way. Please help.

 

The arrow button has the page Navigation action based on the value selected from the second slicer.

semsel_2-1624540840885.png

 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @semsel ,

 

Based on my research, Power bi does not support canceling the default value of single selection.

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 vote for an idea: https://ideas.powerbi.com/ideas/

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @semsel ,


Sorry to disturb you...


But did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Stephen Tao

I was able to achive the required behaviour by keeping below settings:

Top Slicer:

Single-Select ON

 

Bottom slicer:

Single-Select OFF

Multi select with CTRL - ON

v-stephen-msft
Community Support
Community Support

Hi @semsel ,

 

Based on my research, Power bi does not support canceling the default value of single selection.

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 vote for an idea: https://ideas.powerbi.com/ideas/

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!