How to Rename "Select All" option in the slicer to anything else

[Anonymous]

Hi All,

I have a requirement to create a column that can be then used as a slicer in the reports to select the Source system. I am aware that for the slicer I can enable the "Select All" option from the format tab(Selection controls) in PowerBI to select all the values but I don't want to show Select All instead rename it as "Everything" as shown below (since "Select All" may confuse users as I have a SourceSystem named as Select):

I am not sure how can I change my DAX to add "Everything" so that when the user selects it, it will show all the SourceSystems.
Here is my DAX:

SourceSystemName =

SWITCH(

TRUE(),

'Transaction'[IsInProfessional] = True,"Professional",

'Transaction'[IsInSelect] = True,"Select",

'Transaction'[IsInUnlimited] = True,"Unlimited",

'Transaction'[IsInCampus] = True,"Campus",

'Transaction'[IsInProfessional] = True && 'Transaction'[IsInSelect] = True && 'Transaction'[IsInUnlimited] =True ||

'Transaction'[IsInProfessional] = True && 'Transaction'[IsInSelect] = True && 'Transaction'[IsInUnlimited] = False ||

'Transaction'[IsInProfessional] = True && 'Transaction'[IsInSelect] = False && 'Transaction'[IsInUnlimited] =True ||

'Transaction'[IsInProfessional] = True && 'Transaction'[IsInSelect] = False && 'Transaction'[IsInUnlimited] = False ||

'Transaction'[IsInProfessional] = False && 'Transaction'[IsInSelect] = True && 'Transaction'[IsInUnlimited] =True ||

'Transaction'[IsInProfessional] = False && 'Transaction'[IsInSelect] = False && 'Transaction'[IsInUnlimited] =True ||
'Transaction'[IsInProfessional] = False && 'Transaction'[IsInSelect] = True && 'Transaction'[IsInUnlimited] =False ,"Everything"

)

But this does not work and it does not show the value "Everything" which should show me all the records for all the SourceSystems.

Can you please help me resolve it?
Thanks in Advance!

[Anonymous]

Hi @amitchandak,
Thanks a lot! It works like magic 😊

[amitchandak · Accepted solution]

@Anonymous , Maybe you build something like what I have done for single select

Abstract Thesis Part 42: - Single Select with Select All : https://youtu.be/plGqCEZRfXU