Forum Discussion

hcknbrgr's avatar
hcknbrgr
Frequent Visitor
9 years ago
Solved

Merging two Matrix tables into a single Matrix table

Hi all, fairly new to Power BI and DAX. I have created two Matrix tables. Matrix Table 1 uses Product in the Columns section to split out the counts of product purchases.  Table 2 has no Columns fie...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi hcknbrgr,

     

    It is not available to achieve that. By default, we add a column/measure into value section in a matrix visual, it will be grouped automatically. As it shows in above image, the measure/column will show for each group instance.

     

    Best regards,
    Yuliana Gu

hcknbrgr's avatar
hcknbrgr
Frequent Visitor
9 years ago

In the end I went with creating a new calculated column for each product and built the table with fixed columns.  When I created the Dax table my data was now split into two tables and filters on other fields not included in the sample were not applied to the DAX table, so it was easier to keep everything in one table.

Massig's avatar
Massig
Frequent Visitor
7 years ago

Hi 

I am trying to do the same ... 

I am not sure how you did manage to solve this...

I wonder if you could share a bit more details on how you did it...

 

I have 2 tables ... (data is coming from 2 data sets linked)

One where I have

CUSTOMER NAME / FIRST ACTIVITY / ACTIVITY TYPE / LAST ACTIVITY / ACTIVITY TYPE

 

and a second matrix visualization

CUSTOMER NAME / ACTIVITY TYPE 1 / ACTIVITY TYPE 2 etc ... and count of activity type as value.

 

I was trying to have a combined visualization that shows

 

CUSTOMER NAME FIRST ACTIVITY / ACTIVITY TYPE / LAST ACTIVITY / ACTIVITY TYPE and then the matrix part with the count of activity by type.