Forum Discussion

hustlas4ever's avatar
hustlas4ever
New Member
9 years ago
Solved

Matrix Visualization - Columns within a column

  The above image is from an Excel file. I would like to recreate that in Power BI Desktop. By using the Matrix Visualization in Power BI Desktop I did only manage to create this:     ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi hustlas4ever,

     

    The Power BI matrix visual is different from the Pivot table in Excel. The matrix cells display aggregate values that are scoped to the intersection of the row and column groups to which the cell belongs. We are not able to add duplicate columns to the Row or Column groups. So in your scenario, unless the original table contains a specific column group both Ship Date column, then you can get your expected results. You can see attached .pbix.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi hustlas4ever,

 

The Power BI matrix visual is different from the Pivot table in Excel. The matrix cells display aggregate values that are scoped to the intersection of the row and column groups to which the cell belongs. We are not able to add duplicate columns to the Row or Column groups. So in your scenario, unless the original table contains a specific column group both Ship Date column, then you can get your expected results. You can see attached .pbix.

 

 

Best Regards,
Qiuyun Yu