Skip to main content
Microsoft Idea

Power BI

New

Visual - Table & Matrix Combo

Vote (1) Share
Mei Wah Lee's profile image

Mei Wah Lee on 28 Mar 2024 05:11:14

I've a table which each row is for a product, the columns Country/Region, City, Category, Sub-Category and Product Name are displayed. One row is for each product.


I've a matrix which each row is for a product as well. The columns are repeated for each Year-Month. 


I would like to combined both so that the Year-Month columns of the matrix will be displayed on the right hand side of the table. 


I can't use the step-off option in the matrix because the sorted by column of the table is by user selection. So the user can select to sort by either City, Category, Sub-Category or Product Name. The nesting hierarachy in the matrix make it not possible to do such sorting. 


Pls make a table, matrix combo. Thanks!