Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 |
---|---|
116 | |
73 | |
62 | |
50 | |
46 |
User | Count |
---|---|
173 | |
123 | |
60 | |
59 | |
57 |