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

Don'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.

Reply
kennylch
Helper I
Helper I

slicer with default value selected and hidden

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

 

 

5 REPLIES 5
v-jingzhan-msft
Community Support
Community Support

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!

Tahreem24
Super User
Super User

@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.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

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

aduguid
Super User
Super User

You could use the filter pane to achieve this.

can you show an example? cause i didn manage to do this by using filter

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.