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],", "))
This is great help Matt. i have one more question- I am not able to find conditional formatting on the measure created using your formula. Is this feature not available yet? if there is workaround, please let me know.
Conditional formatting is available, but it is hard to find. It is located in the main layout section of the visual, not under formatting options. I think you click on the measure in the values section from memory.
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