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: businessintelligist.com/2021/10/20/how-to-display-multiple-rows-in-a-single-cell-of-a-matrix-or-a-table/
- How to Display Multiple Rows in a single Cell of a Matrix or Table - CONCATENATEX Tutorial ( Download)
- Display Multiple Rows in a single Cell of a card - CONCATENATEX DAX ( Download)
- Power BI - Matrix Visualization - move values from columns to rows ( Download)
- Concatenating Rows into a Single Cell in Power Query | Power BI Tutorial | MiTutorials ( Download)
- Using CONCATENATEX in DAX ( Download)
- ConcatenateX in Power BI and DAX Concatenate Values of a Column ( Download)
- How to Merge Cells in Power BI Matrix Table ( Download)
- Create insightful calculations using CONCATENATEX. ( Download)
- Ultimate Guide to MATRIX Tables in Power BI | 2023 ( Download)
- CONCATENATE, CONCATENATEX - DAX Guide ( Download)
- Use Power BI, Power Query to Combine ( Concatenate, Merge ) multiple rows into a single row value. ( Download)
- HANDLING WITH MULTIPLE VALUES IN ONE CELL - POWER BI ( Download)
- Using Column as measure in Power BI table/matrix ( Download)
- Displaying Multiple Total Rows in a Matrix Visual in Power BI: The Possibility Unveiled ( Download)
- Expand and collapse rows in Power BI | Matrix Tables ( Download)
