How to Display Multiple Rows in a single Cell of a Matrix or Table - CONCATENATEX Tutorial

How can I condense multiple rows into a single cell in a Matrix or a Table?
Obviously, it is easy to display all details, but what if i just want to see a list of countries, channels, etc where my product is selling without showing all permutations of those data elements?

Turns out we have to write a bit of DAX but thankfully, not much at all using one of my favorite functions CONCATINATEX()

#powerbi #mspowerbi #knowledgebank #tutorial #data

[elondelport]

HI Thank you this works briliantly as a measure do you know of a way to do this as a column and not in Power quarry

[rogervandecraen]

As always a very usefull tip, well explained and a simple measure to solve it!

[stephencross]

Brilliant video, this just really helped me, thanks!

[aliyeselinulu]

Could you explain how you displayed only distinct values in the cells? When I tried, I got something like:
Product E •Japan •Dealer
•Japan •Direct
•Japan •eCommerce
•Spain •eCommerce
•USA •Dealer

[InonoYazy]

Amazing! It's a pity there in no standard chart for it

[ankonbiswas]

If I try to add background colors depending on the different row values for one single unique row. Power bi treats that row(with several values) as a single row. Hence the whole row displays the same color even if it is supposed to display a different color depending on the value. How to fix that?

[oricchannel]

Very useful tip. Thank you for sharing !

[torbjornbergvall]

Any ideas on how you can present the countries as comma separated values insted of list?

[sylvainpetiteau]

thanks for this usefull video. Would it be possible to a have multiple sums condensed in a cell?

[varunmachupally]

How to highlight single value in those bullet points?

[blackcoffeeandeggwhites]

Can we have dynamic numbers as 1. Japan 2. Spain 3. USA instead of bullets somehow?

[joshuaychung]

UNICHAR(10) & UNICHAR(13) make me miss vbCrLf.

[itsperex]

I my opinion it is not very useful when you can display it in a matrix and be able to see the "amount" grouped and detailed in a dynamic way.