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.

     

    Regards

    Ravichandra JL

     

    • Stachu's avatar
      Stachu
      Community Champion
      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"
)
      • ravichandra0788's avatar
        ravichandra0788
        Frequent Visitor
        8 years ago
        Thanks Stach :)
  • 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