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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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

sdjensen's avatar
sdjensen
Solution Sage
9 years ago

Imagine how awesome it would be if you were able to hide all values of a measure in a table/matrix for still show the total.

 

I believe this feature is coming to the new table/matrix visuals, but is't not there yet.