Forum Discussion
Solved
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?
Unicorn_Tech , create this as measure and add that to visual
measure= concatenatex(Table, Table[Items], " ,")
3 Replies
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], " ,")
