topic Re: How to Convert Column Into Delimited List in Report Server

How to Convert Column Into Delimited List

Anonymous — Mon, 19 Jul 2021 10:08:19 GMT

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

Fowmy — Mon, 19 Jul 2021 10:55:50 GMT

Anonymous

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

ID List = CONCATENATEX ( DISTINCT (tablename[IDs]), tablename[IDs], ", " )

Anonymous — Mon, 19 Jul 2021 12:49:42 GMT

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

Thanks,

Pravin