Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous
You use a measure as follows.
Measure =
IF(
HASONEVALUE('Data Domain'[Financial Insights Improvements]),
SELECTEDVALUE('Data Domain'[Financial Insights Improvements]),
"All Improvements"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
@Anonymous
You use a measure as follows.
Measure =
IF(
HASONEVALUE('Data Domain'[Financial Insights Improvements]),
SELECTEDVALUE('Data Domain'[Financial Insights Improvements]),
"All Improvements"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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],
","
),
" "
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |