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
Hello,
I have column name "Status" in my dataset. In this column values like "Won","Open","Lost".
I want to make WON and OPEN “pre-selected” and LOST (Not Checked)
If someone wants to see “Lost” they will have to select that.I want my two value should be checked by default and One should uncheked if user want then they can . I want to filter my slicer like this in power bi.
@RuchiK ,
so as i mentioned it will be published like this and the user can check / uncheck
Proud to be a Super User! | |
Yes, but user can uncheck "Won" and "Open". This is not require. I want to make this values always be checked.
@RuchiK ,
this is not possible to force check some fields and have the ability to check / uncheck a certain field in a slicer.
Proud to be a Super User! | |
Hello @Idrissshatila ,
Is there any alternative to achieve this solution? Any custom visual for filteration I mentioned?
@RuchiK , I honestly never seen something like this.
Proud to be a Super User! | |
Hello @RuchiK ,
so you add a slicer and you cselect the values you want and publish it to server, then it will be by default as you checked and the user can un select as he wants.
Proud to be a Super User! | |
No this is not what I want. Values must be checked by default if user want to make "Lost" check/uncheck they can.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |