Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 th...
Need Help
Tutorial Requests
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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-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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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