Forum Discussion

ravichandra0788's avatar
ravichandra0788
Frequent Visitor
8 years ago
Solved

Regarding multiple values display in KPI

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 'c...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    I wrote from memory, expression is missing

    DepartmentNames =
IF (
    ISFILTERED ( dept[DNAME] ),
    "selected departments are "
        & CONCATENATEX ( VALUES ( dept[DNAME] ), dept[DNAME], ", " ),
    "No department selected"
)
Stachu's avatar
Stachu
Community Champion
8 years ago

try this

DepartmentNames = IF(ISFILTERED(dept[DNAME]),"selected departments are " & CONCATENATEX(VALUES(dept[DNAME]),", "),"No department selected")
ravichandra0788's avatar
ravichandra0788
Frequent Visitor
8 years ago

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