- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Unicorn_Tech , create this as measure and add that to visual
measure= concatenatex(Table, Table[Items], " ,")
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Unicorn_Tech , use concatenatex
concatenatex(Table, Table[Items], " ,")
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Unicorn_Tech , create this as measure and add that to visual
measure= concatenatex(Table, Table[Items], " ,")
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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-09-2024 12:42 AM | |||
01-04-2024 07:57 AM | |||
07-26-2024 08:19 AM | |||
07-15-2021 02:06 AM | |||
04-30-2024 07:19 AM |
User | Count |
---|---|
113 | |
76 | |
56 | |
55 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |