Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Maximous89
Frequent Visitor

Slicer Single select

in power bi slicer i have 5 choices and i want to make this slicer and single select and i already achieved this, but now i want one choice to be always selected and the user choose only one selection from other 4 choices?

 

so lets say i have (A,B,C,D,E,F) in same column.

so i want A to be always selected and user choose from the rest.....any ideas?!

2 ACCEPTED SOLUTIONS
Shahid12523
Community Champion
Community Champion

Use a disconnected slicer table with values B–F, set to single select, and hardcode “A” into your DAX logic so it's always included. This way, users can only pick one extra value, and “A” stays selected behind the scenes

Shahed Shaikh

View solution in original post

ryan_mayu
Super User
Super User

@Maximous89 

 

11.png

 

pls see the attachment below

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
ryan_mayu
Super User
Super User

@Maximous89 

 

11.png

 

pls see the attachment below

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




v-hashadapu
Community Support
Community Support

Hi @Maximous89 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

v-hashadapu
Community Support
Community Support

Hi @Maximous89 , Thank you for reaching out to the Microsoft Community Forum.

 

We find the answer shared by @Shahid12523  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily

 

Thank you @Shahid12523  for your valuable response.

Shahid12523
Community Champion
Community Champion

Use a disconnected slicer table with values B–F, set to single select, and hardcode “A” into your DAX logic so it's always included. This way, users can only pick one extra value, and “A” stays selected behind the scenes

Shahed Shaikh
PijushRoy
Super User
Super User

Hi @Maximous89 

In the Slicer setting, please select Single Select
Select the A and publish the report. Once the user opens the report, they can always see the A selected as you publish this selection.




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





yes, but then how they can select A and B or A and C, it's single select not multi select, so i want user to found A always selected and choose single select from B,C,D,E,F....

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.