Forum Discussion
Solved
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...
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], " " )
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!