The default "All" of a dropdown have to be replaced with custom Text

[Anonymous]

Hi,

I have a slicer for shopping store. The default value "All" of that drop down need to be replaced with a custom text like
"Please select store". It is a multi selection dropdown not a single selection.

So, can we replace the default value with the custom text using DAX or is any other custom visual where we can change the custom text.

Can anyone please help on this. 

Regards, 
Sirisha.C

[Anonymous]

Hi @Anonymous ,

Currently, we cannot customize the default value of "ALL" to other values such as "Please select store" in Format.

I suggest you try to create a card visual by a measure which will return dynamic text result based on selection and group this card and segmenter to achieve your goal.

Here I create a sample.

Measure:

Measure = 
VAR _countrow =
    COUNTROWS ( 'Shopping Store' )
VAR _Total =
    COUNTROWS ( ALL ( 'Shopping Store' ) )
RETURN
IF(
ISFILTERED('Shopping Store'[Shopping Store]),    
IF (
        _countrow = 1,
        SELECTEDVALUE('Shopping Store'[Shopping Store]),
       "Multiple Selections" 
    ),
"Please select store")

Create a card visual by this measur, turn off "Category label", set Text size and Font the same like your slicer. Then use Ctrl + left click to mulitiple select visuals and right click to use Group function.

Result is as below.

Befault it will show "Please select store".

One selection:

Multiple selection:

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted

Best Regards,
Rico Zhou

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

[Anonymous]

Hi,

If Select ALL is enabled how do we deal with it. Could you please help me with that too.

Regards,

Sirisha

[Anonymous · Accepted solution]

Hi, 

Thanks for responding. It's a good idea. Actually I have tried with a card. But as I am using SSAS model grouping of the card is not possible. Is there anyway istaed of grouping.

Could you please help on this.

Regards,

Sirisha.C

[Anonymous]

Hi @Anonymous ,

I mean group visual function. Here I have a test by connect to SSAS by live connection mode. It works well.

Best Regards,
Rico Zhou

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

[Anonymous]

Hi,

My data source is Analysis service and when I tried to group the card it's disabled and also

SELECTEDVALUE('Shopping Store'[Shopping Store])

SELECTEDVALUE function is not available in the anaysis service model.

If there is any other alternative of that function. Could you please help me on this. 
SO far your idea helped me a lot. Please help on that part.

Regards,

Sirisha.C

[amitchandak]

@Anonymous , I doubt there is an option for that