Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to Convert Column Into Delimited List

Hi Community,

 

I want to Convert Column into List. Please find below details.

 

Dataset = Select Distinct ids from table

Output of dataset:

IDs

123

456

789

 

So i want to display these values in taxtbox as 123,456,789

 

 

Thanks,

Pravin

column to row
report builder

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    You can create a measure as follows and use it on a card visual:

    ID List = 

CONCATENATEX (
    DISTINCT (tablename[IDs]),
    tablename[IDs],
    ", "
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy  I want it in power Bi Report Builder not in Power BI Desktop.

       

      Thanks,

      Pravin