Select All in the slicer (possible to customize it, like i want to show Overall)

[vjnvinod]

hello Experts

i am using  a slicer as you see below, what i want is to Show Select all text as Overall

is there anyway to do it, other thn bookmarking?

[suparnababu8]

Hi @vjnvinod  - This is directly not possible with native slicer options. I agree @danextian  answer, You may follow the same. Thanks

[danextian · Accepted solution]

Hi @vjnvinod 

The word select all in the slicer cannot be changed. You can use a disconnected table containing the word overall plus the other texts and use a measure to return the desired value based on slicer selection. This measure is to be used as a visual filter. The second option to is to create  a separate dimensions table like below which will create a many to many relationship  - performance with a small table is negligible but can be obvious with large tables.

Both these approaches are in the attached pbix.