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],", "))
Hi Matt,
As you can see in the picture above, I am only able to find two options- 'Remove field' and 'Quick Calc' and not the conditional formatting option. For normal columns which were directly pulled from excel, I was able to see conditional formatting option.
I guess you don't have the latest version of Power BI Desktop. I just checked and it is definitely there
MattAllington I think conditional formatting only works on measures that return numerical values. I have a matrix with 2 measures, one that returns a whole number and another that returns text. Conditional formatting is only available on the number.