How to Rename Card Value as 'All' for 'select all' Option in power bi

[Anonymous]

Hi I have a data with 5 enteries as shown in below image-

I have assigned card in powerbi value of this column so the card value is changing based on user selection as shown below

1)

    

2)

My question is that when I have all the data domain selected from slicer in my dashboard the powerbi is showing the card value as 'Financial Insights Improvements' which is the very first entry in data set.

but i want once all the data domain values are selected then the powerbi card should show value as 'All Improvements' instead of 'Financial Insights Improvements'

is that possible??

I am really confused how to proceed with that. Please help

[SushainKoul]

Hi @Anonymous ,

As far as what I have understood. These datas which u have inserted are in a slicer I guess. So there is no way u can get "All" when u select all options but there is one way that instead of displaying "All" which u want u can display the names of all the values that are selected. If u want and if that helps u then I can tell u otherwise I am sorry there is no other way to achieve what u r asking for.

[Fowmy · Accepted solution]

@Anonymous 

You use a measure as follows.

Measure = 

IF(
    HASONEVALUE('Data Domain'[Financial Insights Improvements]),
    SELECTEDVALUE('Data Domain'[Financial Insights Improvements]),
    "All Improvements"
)

[Anonymous]

Thank you It worked

[Lucas2M]

you could use the 

CONCATENATEX funtion als alternative to show de different selected options concated eg

d_title = IF (
ISFILTERED ( Data Domain ),
"selected : "
& CONCATENATEX (
ALLSELECTED (
'Data Domain'
),
'Data Domain'[Financial Insights Improvements],
","
),
" "
)