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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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