topic Re: Urgent Help: How to rename the 'select all' option to say 'all products' in a slicer in DAX Commands and Tips

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

Anonymous — Sun, 07 Apr 2024 17:27:34 GMT

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??

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

lbendlin — Sun, 07 Apr 2024 18:38:15 GMT

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

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

Anonymous — Tue, 09 Apr 2024 08:08:28 GMT

Hi Anonymous ,

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.

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

F2THEB — Tue, 13 May 2025 14:01:56 GMT

An option to simply change the "ALL" text on a slicer should have been implemented years ago. It's 2025 now. Can't believe this is still no option.