Remove "Clear Selections" options from Slicer

[Anonymous]

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

[Thejeswar · Accepted solution]

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