Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
deepanwita25
Frequent Visitor

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

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

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

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

View solution in original post

v-kaiyue-msft
Community Support
Community Support

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.

vkaiyuemsft_0-1712649912128.png

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

Table =

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

RETURN

_country

vkaiyuemsft_1-1712649958067.png

 

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

vkaiyuemsft_2-1712649968383.png

 

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.

vkaiyuemsft_3-1712650004137.png

 

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.

vkaiyuemsft_4-1712650018249.png

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.

View solution in original post

2 REPLIES 2
v-kaiyue-msft
Community Support
Community Support

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.

vkaiyuemsft_0-1712649912128.png

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

Table =

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

RETURN

_country

vkaiyuemsft_1-1712649958067.png

 

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

vkaiyuemsft_2-1712649968383.png

 

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.

vkaiyuemsft_3-1712650004137.png

 

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.

vkaiyuemsft_4-1712650018249.png

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
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors