Forum Discussion
Solved
Text in a Matrix
Hello all, I am trying to create a dashboard that displays some information in a matrix, but the problem I am having is that the value field I want to display is actually a string. It is a code ...
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],", "))
