Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?!
Solved! Go to Solution.
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
pls see the attachment below
Proud to be a Super User!
pls see the attachment below
Proud to be a Super User!
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.
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.
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
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.
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....
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |