Urgent Help: How to rename the 'select all' option to say 'all products' in a slicer

[deepanwita25]

Hello,

I have a multiselect slicer that has select all option in it. My slicer is also filtered from the filter pane by 'filter on this visual'. So, things filtered appear in the slicer. Because its a multiselect, I also have the select all option switched on from the visualization>>Format.

I want to edit the 'Select All' to say 'All products'. I have created a calculated table for this but now the issue is 'All products' is all the products present in my dataset and not the cumulation of products from the filter pane. I want to rename 'select all' to 'all products' and this should be equivalent to only the products selected in the filter. Can someone help please urgently??

[lbendlin · Accepted solution]

Not currently possible (no matter if urgent or not)

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[v-kaiyue-msft · Accepted solution]

Hi @deepanwita25 ,

Good point @lbendlin , currently power bi doesn't support directly renaming slicer's full options. But one can get to achieve this with the help of dax expressions.

1. have these countries in my table.

2. create calculated table without creating relationship with original table.

Table =

VAR _country = DISTINCT('financials'[Country])

RETURN

_country

3. use country in the calculation table as a filter throughout the page.

4. create MEASURE.

Measure =

var _column=SELECTEDVALUE('Table'[Country])

var _flag=

CONCATENATEX(

ALLSELECTED('Table'),

'Table'[Country], "-"

)

RETURN

IF(

CONTAINSSTRING(

_flag,MAX('financials'[Country]))=TRUE()

,1,0)

5. Only data with a MEASURE value of 1 is displayed.

6. This method can't directly change the name of the Select All button, but clearing the filter will show the content of all filters.

Also, this solution may inspire you: Solved : How to Rename "Select All" option in the slicer to... - Microsoft Fabric Community.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Not currently possible (no matter if urgent or not)

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41