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)

    

 

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

 

 

 

 

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

     

     

4 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper 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

  • SushainKoul's avatar
    SushainKoul
    Icon for Helper III rankHelper III
    5 years ago

    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.