Rename ALL value in dropdown slicer?

[lawrenceabith]

Hi Everyone!

I have a slicer. i.e. ALL 2016 2017 2018. When I set it to a dropdown, the default value visible is "ALL." Is it possible to rename the ALL to whatever I want so instead of seeing ALL?

Many thanks!!!

[v-rzhou-msft · Accepted solution]

Hello @lawrenceabith

Currently, we cannot customize the default value of "ALL" to other values such as "All Field Name" in format.

But we can build a visual card by one measure and group this visual and segmenter to achieve its goal.

I build a slicer table.

build a measure.

Measure =
VAR _countrow =
    COUNTROWS ( 'Table' )
VAR _Total =
    COUNTROWS ( ALL ( 'Table' ) )
RETURN
    IF (
        _countrow = 1,
        MAX ( 'Table'[Year] ),
        IF ( _countrow < _Total, "Multiple Selections", "All name of the field" )
    )

Display this measurement in Card Visual and Segmenter and Visual Card group.

'

The result is as follows.

Default:

select 2017:

Select 2017&2018:

You can download the pbix file from this link: Rename the ALL value in the drop-down segmentation?

You can vote on an idea using this link for this feature: https://ideas.powerbi.com/ideas/search-ideas/

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

Hi, 

I have country dropdown and the "ALL" value have to be replaced with a custom text. 
Could you please me with your DAX. I have tried the same DAX that you have used with date field. 

But as I am using the country field which is a text field i am facing difficulty of counting the rows and Max of the rows as it's a text field it's throwing an error. 

Please kindly help on this if the dropdown field is a text field "All" have to be replaced with a custom text

Regards,

Power Bi User.

[paulsnet1986]

Hi, - I am trying to recreate this suggestion with no luck and the link to the PBIX no longer works. Could you please explain what to do with the measure once created?

[lawrenceabith]

Hi @v-rzhou-msft,

Awesome idea! I'll try and back to you if it works.

Many thanks!!

[Greg_Deckler]

@lawrenceabith  - If your slicer table only contains 2016, 2017 and 2018, then no, that is a default "All" that appears. You can turn on single select to get rid of it but I know of no way to change it from All to something else.

[lawrenceabith]

Hi @Greg_Deckler,

I need to change "All". Because I have an app using Power BI embedded and I need to change the name from "All" to "All name of the field"

Many thanks,

[AllisonKennedy]

You can use the dynamic title formatting maybe to give the slicer a title that says "All name of field". Would that help? https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles

[Greg_Deckler]

@lawrenceabith - There may be some magical method to do that in embedded experience somehow but I am not aware of anything of anything in the slicer visual that will allow you to do that in the Desktop or the Service. You could look for a third-party visual that let's you do that or maybe get the code for the slicer visual and modify and create your own visual. Only other thing I can think of would be to create a seperate, disconnected table with the values:

All Years

2016

2017

2018

Then turn on single select. Then code a measure to act appropriately given the slicer value. That's about all of the ideas that I have.