Reply
Unicorn_Tech
Resolver I
Resolver I
Partially syndicated - Outbound

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

Syndicated - Outbound

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

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

Syndicated - Outbound

@Unicorn_Tech , use concatenatex

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Syndicated - Outbound

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.

Syndicated - Outbound

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

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)