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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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], " ,")

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Unicorn_Tech , use concatenatex

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

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], " ,")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.