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.