Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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)...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You use a measure as follows.

    Measure = 

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

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

You use a measure as follows.

Measure = 

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

 

 

  • Lucas2M's avatar
    Lucas2M
    New Member
    5 years ago

    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],
    ","
    ),
    " "
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you It worked