topic Re: DAX for replacing " ALL " in a drop down slicer to a custom text in DAX Commands and Tips

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

Anonymous — Fri, 29 Apr 2022 10:56:13 GMT

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.

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

lbendlin — Mon, 02 May 2022 12:42:06 GMT

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

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

Anonymous — Wed, 04 May 2022 07:15:33 GMT

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