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 va...
column to row
report builder
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