The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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],
","
),
" "
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |