Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ravichandra0788
Frequent Visitor

Regarding multiple values display in KPI

Hi ,

 

I have a dataset like below 

 

DEPTNODNAMELOC
10ACCOUNTINGNEW YORK
20RESEARCHDALLAS
30SALESCHICAGO
40OPERATIONSBOSTON

 

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.

 

Capture.JPG                                                     Help required is : If i select multiple values it is displaying error.Here is the screenshot.

 

Capture.JPG                                                      Could you please help me how to resolve this issue.

 

Regards

Ravichandra JL

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


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

5 REPLIES 5
Stachu
Community Champion
Community Champion

try this

DepartmentNames = IF(ISFILTERED(dept[DNAME]),"selected departments are " & CONCATENATEX(VALUES(dept[DNAME]),", "),"No department selected")


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Hi Stachu,

 

Thanks for the quick response ,However suggested solution is not working.

 

Here are screenshots.

 

Case 1: If no departments selected.

 

Capture.JPG                                                                           Case 2: if one department selected.

 

Capture.JPG                                                                             Case 3 : if multiple departments selected 

 

Capture.JPG                                                                                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"
)


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Thanks Stach 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.