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
Anonymous
Not applicable

Remove "Clear Selections" options from Slicer

Hi, 

 

I have a report with a slicer filter for Projects (single selection) which is controlling the title of the report (I have used a Card to show the title). The problem i have is when/if the user will Clear Selections from the filter - then the report will show information for all the projects but the title will show the name of the first project.

 

Is there a way to either remove the Clear Selections from the filter or to show in the title "All Projects" when the filter is showing all projects?

 

Thank you,

Ioana

1 ACCEPTED SOLUTION
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

You can hide the clear selection option in the slicer by hiding the Header of the slicer. In order to show the slicer name, use the title option in the properties

 

In case you want to show "All Projects" when the selections are cleared, you can create a measure that use a DAX similar to the below one

 

 

Measure = IF(NOT(ISFILTERED(ProductSubcategory[EnglishProductSubcategoryName])),"ALL",ProductSubcategory[EnglishProductSubcategoryName])

The First option is a simple one and should be a go to option as well

View solution in original post

1 REPLY 1
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

You can hide the clear selection option in the slicer by hiding the Header of the slicer. In order to show the slicer name, use the title option in the properties

 

In case you want to show "All Projects" when the selections are cleared, you can create a measure that use a DAX similar to the below one

 

 

Measure = IF(NOT(ISFILTERED(ProductSubcategory[EnglishProductSubcategoryName])),"ALL",ProductSubcategory[EnglishProductSubcategoryName])

The First option is a simple one and should be a go to option as well

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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