cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saurabh255
New Member

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-

 

saurabh255_0-1622716375550.png

 

 

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

1)

saurabh255_1-1622716507545.png    

 

2)

saurabh255_2-1622716538742.png

 

 

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

 

 

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User IV
Super User IV

@saurabh255 

You use a measure as follows.

Measure = 

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

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Blog - Data Visualization

Website   YouTube    LinkedIn   PBI User Group

View solution in original post

4 REPLIES 4
SushainKoul
Helper III
Helper III

Hi @saurabh255 ,

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
Super User IV
Super User IV

@saurabh255 

You use a measure as follows.

Measure = 

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

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Blog - Data Visualization

Website   YouTube    LinkedIn   PBI User Group

View solution in original post

Thank you It worked

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors