Question about Matrix Data Representation and Text Fields

[gabrielfsouza1]

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?

[DataNinja777 · Accepted solution]

Hi @gabrielfsouza1 ,

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,

[gabrielfsouza1]

@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 well

[DataNinja777]

Hi @gabrielfsouza1 

What about using ConcatenateX in conjunction with the filter function to only get the latest status with respect to the time dimention? 

Best regards,

[Ritaf1983]

Hi @gabrielfsouza1 

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/1447523

[Ritaf1983 · Accepted solution]

Hi @gabrielfsouza1 
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-8d032c09249b

As 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 · Accepted solution]

Hi @gabrielfsouza1 ,

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,