Forum Discussion
Text in a Matrix
Yes you can do this, but only when the string returns a single value. Write a measure something like this
=if(hasonevalue(table[column]),values(table[column]))
there is a new function called concatenatex that allows you to build a string of values on the fly in the instance that there is more than a single value returned. Just google the syntax.
=if(hasonevalue(table[column]),values(table[column]),concatenatex(table,table[column],", "))
Yes you can do this, but only when the string returns a single value. Write a measure something like this
=if(hasonevalue(table[column]),values(table[column]))
there is a new function called concatenatex that allows you to build a string of values on the fly in the instance that there is more than a single value returned. Just google the syntax.
=if(hasonevalue(table[column]),values(table[column]),concatenatex(table,table[column],", "))
How can we add new line charatcers in a visualisation, specifically a matrix or table. It seems you can't do it. This concatenex is almost there n terms of concatenating text values into a measure, but I want to put each component piece of text on a new line, not just separate with a delimter. It looks like even if you have a new line character in your source data and just display in a table the new line characters are removed and it all goes on a single line.