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
Link to blog and the model: businessintell...

[@rogervandecraen9797]

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

[@KnowledgeBankPro]

Ty sir!

[@stephencross4978]

Brilliant video, this just really helped me, thanks!

[@KnowledgeBankPro]

you are welcome!

[@InonoYazy]

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

[@KnowledgeBankPro]

true but we gotta do what we can with what we got

[@elondelport98]

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

[@aliyeselinulu629]

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]

It worked, Thank you!

[@KnowledgeBankPro]

that's awesome!

[@oricchannel2811]

Very useful tip. Thank you for sharing !

[@KnowledgeBankPro]

You are very welcome

[@ankonbiswas6054]

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?

[@torbjornbergvall8374]

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

[@sylvainpetiteau7030]

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

[@masgitz]

Gold

[@KnowledgeBankPro]

Ty sir

[@varunmachupally3234]

How to highlight single value in those bullet points?

[@KnowledgeBankPro]

you can't, you can only highlight entire cell

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

[@KnowledgeBankPro]

:)

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