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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.