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 dataset like below
DEPTNO | DNAME | LOC |
10 | ACCOUNTING | NEW YORK |
20 | RESEARCH | DALLAS |
30 | SALES | CHICAGO |
40 | OPERATIONS | BOSTON |
Now in powerBI i am using 'chicklet slicer' visual so that it will display selected department name in KPI visual.
For this i have created a measure:
DepartmentNames = IF(ISFILTERED(dept[DNAME]),CONCATENATE("selected departments are ",VALUES(dept[DNAME])),"No department selected")
here is the screen shot.
Help required is : If i select multiple values it is displaying error.Here is the screenshot.
Could you please help me how to resolve this issue.
Regards
Ravichandra JL
Solved! Go to Solution.
I wrote from memory, expression is missing
DepartmentNames = IF ( ISFILTERED ( dept[DNAME] ), "selected departments are " & CONCATENATEX ( VALUES ( dept[DNAME] ), dept[DNAME], ", " ), "No department selected" )
try this
DepartmentNames = IF(ISFILTERED(dept[DNAME]),"selected departments are " & CONCATENATEX(VALUES(dept[DNAME]),", "),"No department selected")
Hi Stachu,
Thanks for the quick response ,However suggested solution is not working.
Here are screenshots.
Case 1: If no departments selected.
Case 2: if one department selected.
Case 3 : if multiple departments selected
Request you to help here.
Regards
Ravichandra JL
Hi Stachu,
Thanks for the quick response,However suggested solution is not working.
Regards
Ravichandra JL
I wrote from memory, expression is missing
DepartmentNames = IF ( ISFILTERED ( dept[DNAME] ), "selected departments are " & CONCATENATEX ( VALUES ( dept[DNAME] ), dept[DNAME], ", " ), "No department selected" )
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |