The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
There is a value in the slicer which i want it always selected and hidden from end user. So that user cant uncheck the value. or any other alternative to do so?
For instance
I want to include this ID 001 for all the visual to display its data. But in the slicer i want to hide the ID 001 so that the user not able to deselect ID 001
Hi @kennylch
I find a similar thread. Please check if the solution there works for you!
Is there a way to make a slicer option always sele... - Microsoft Fabric Community
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
@kennylch You can first apply this ID 001 value in report level or page level filter as per the need. Then create a new column in which you can remove this ID 001 or replace it with blank and only use for this slicer.
It doesnt seems working.
For instance. The column name 'DOCUMENT'. I set page default filter = ALL
The i created a new column from this DOCUMENT folder and exclude the ID001
Then create a slicer and user this new column. But it will still exclude the ID001 row
You could use the filter pane to achieve this.
can you show an example? cause i didn manage to do this by using filter
User | Count |
---|---|
61 | |
59 | |
50 | |
48 | |
35 |
User | Count |
---|---|
148 | |
85 | |
69 | |
48 | |
47 |