Forum Discussion
Question about Matrix Data Representation and Text Fields
Hello everyone!
I would like to create a Matrix where the data remains as shown in the print below, but when adding the TEXT field to the matrix values, it only takes the first data it found, and that would be wrong. Is there any way to solve this?
Or is there another matrix that I can download from the market?
Hi Anonymous ,
You can flexibly create visualizations of text string outputs using ConcatenateX function. The syntax is super-simple, and it is my favorite dax function.
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
Best regards,
Hi Anonymous
Unfortunately matrix isn't support unaggregated values.
There is an idea about this issue you can vote for it by the link :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f4885a2-e130-4852-aefc-8d032c09249bAs an alternative, you can try to create a measure using concatenateX .
(Will work not bad id there is not much data on the cell level)Something like this with a comma :
Categories = CONCATENATEX(values('Products'[Category]),[Category],",")OR with unichar (10 )to see every value on another row:
Categories 2 = CONCATENATEX(values('Products'[Category]),[Category],UNICHAR(10))pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
5 Replies
Hi Anonymous ,
You can flexibly create visualizations of text string outputs using ConcatenateX function. The syntax is super-simple, and it is my favorite dax function.
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
Best regards,
Hi Anonymous
Unfortunately matrix isn't support unaggregated values.
There is an idea about this issue you can vote for it by the link :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f4885a2-e130-4852-aefc-8d032c09249bAs an alternative, you can try to create a measure using concatenateX .
(Will work not bad id there is not much data on the cell level)Something like this with a comma :
Categories = CONCATENATEX(values('Products'[Category]),[Category],",")OR with unichar (10 )to see every value on another row:
Categories 2 = CONCATENATEX(values('Products'[Category]),[Category],UNICHAR(10))pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
DataNinja777 Ritaf1983 Thank you very much for the response!
But if I concatenate, it won't help me because today in Power BI, if my process ran 3 times, it will bring the statuses Failed, Completed, and Updating. The correct thing is to bring only Updating, but sometimes it brings Failed because it is programmed to bring only the first in the matrix field, and I set it to bring the last one, but it takes it randomly sometimes it works, sometimes it doesn't.
If I concatenate, it will bring all 3, but the visualization would be very poor because I wanted only 1 status.
Sorry for my English, I don't speak the language very wellHi Anonymous
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Anonymous
What about using ConcatenateX in conjunction with the filter function to only get the latest status with respect to the time dimention?
Best regards,