Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Unicorn_Tech
Resolver I
Resolver I

Transpose values into text, commas

Hello.  I'm wondering if there is any easy way to do this.

I have a visual in a simple grid that looks like this:

Items
Value1
Value2
Value3

 

I would like a visual that looks instead like:

Items:

Value1, Value2, Value3 etc.

 

is there a visual that will do this? Basically representing the values as a string of text?

1 ACCEPTED SOLUTION

@Unicorn_Tech , create this as measure and add that to visual

measure= concatenatex(Table, Table[Items], " ,")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Unicorn_Tech , use concatenatex

concatenatex(Table, Table[Items], " ,")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi.  Thanks for the reply. I'm not familiar with how to create a visual that will do that - or do you mean a seperate table? Can you please give me a little more info?  Thanks.

@Unicorn_Tech , create this as measure and add that to visual

measure= concatenatex(Table, Table[Items], " ,")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.