Forum Discussion
Looking for a matrix inside matrix visual
Hi,
I'm looking for a way/a visual that will allow me to create a matrix inside another matrix as below.
I have table with 3 columns: city, customer and month. I would like to join each customer number with city and month and then show it as a text in the table as below. Is that even possible in Power BI? Preferably with conditional formatting option.
Unfortunately a native matrix visual can't handle it.
Do you have idea which visual could I use to create something like that?
Many Thanks in advance,
Adam.
Hi foks ,
I have searched custom visuals in APPSource. Unfortunately, there is not a visual that can implement your requirement. As a workaround, maybe you could create a measure to show all values of customers in one cell, like below:
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table' ), 'Table'[City] <= MAX ( 'Table'[City] ) && 'Table'[Month] <= MAX ( 'Table'[Month] ) ), 'Table'[Customer], " " )
4 Replies
Hi foks ,
I have searched custom visuals in APPSource. Unfortunately, there is not a visual that can implement your requirement. As a workaround, maybe you could create a measure to show all values of customers in one cell, like below:
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table' ), 'Table'[City] <= MAX ( 'Table'[City] ) && 'Table'[Month] <= MAX ( 'Table'[Month] ) ), 'Table'[Customer], " " )v-xuding-msft thanks a lot!
When do you add more rows or columns that should give you that? Can you explain with data display example
Hi amitchandak,
So my fact table looks like that:
When I try to create a matrix and put city into rows, month into columns and customer into values, I got only first customer in each cell:
My goal is to have all customers as a separate cell, inside the current matrix. I cannot find any visual that can manage that.
