DAX for replacing " ALL " in a drop down slicer to a custom text

[Anonymous]

Hi All,

I have a requirement like replacing the "All" with a custom text.

For example a I have a Shopping Store multi selection drop down. The default value "All" have to be replaced with a custom text "Please select store".  Can any one help me with the DAX for masking the slicer with a card so that it displays
1. custom text when nothing is selected
2. "Multiple Selections" when more than one store is selected.
3. Displays the selected value when a single store is selected. ,

The data source i am using for the report is a analysis service. Please help on this. 
If there is any custom visual which achieves the same.

Regards,

Power Bi User.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Base on my research, there is no settings to customize the text when no option selected on the slicer.

Please try the method(see attachment) and check if it can be used as an workaround.

1. Create a measure as below

Measure = IF ( NOT ( ISFILTERED ( 'Table'[Weeks-2] ) ), "Please select store", "" )

2. Create a card visual and put the measure onto it

Best Regards

[lbendlin]

None of this is even remotely possible.  You may need to write your own custom visual, but even then that is still a stretch.