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],", "))
Sorry for the delayed response, I got pulled away on other projects and just got to test this out today. Thank you!
That worked like a charm. My only other question would be (and I think the answer is no but I'm being picky), is there any way I can add columns after the pivoted column in a matrix?
In other words if my "columns" value that is being pivoted is product code, and I want the matrix to look comething like:
Order | Customer | Product Codes ... | ... | ...| Due Date | Etc |
Is that possible?
Thanks again!
This can be done easily in Excel with Fields, Items and Sets, but I don't believe it can be done today in Power BI. There are some table updates coming shortly (improved visuals) so let's see if there is any change then.
How do we add a new line character as a delimter so each component text value is on a new line. It seems like even if the data source itself has new lines / carriage returns the matrix & table visualisations (in fact any visualisation) ignores new lines and puts everything on a single line
Thanks
Anthony
How do we add a new line character as a delimter so each component text value is on a new line. It seems like even if the data source itself has new lines / carriage returns the matrix & table visualisations (in fact any visualisation) ignores new lines and puts everything on a single line
Thanks
Anthony
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.
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.
