Matrix

[vejas]

Hi, 

  My goal is to see in one matrix - product sale made by year and by cutomer and product warehouse quantity today. 

I have two measure Sales  and Inventory and made matrix like this:

Sales are good, but Inventory is splited by year and customer too and that is bad. 

I want see table like this :

Sales splited by year and customer, Inventory just by Product.

What i need to do to get this ?

Thanks

[vejas · Accepted solution]

Just needed to create Calculated column Inventory Quantity in Product table ( instead of measure in Inventory table) and put it in Matrix Rows between Product and Customer. 

[Anonymous]

Hey @vejas 

Matrices with multiple headers is tricky. However, it has been solved in both ofthe below threads:

Unpivot data: https://community.powerbi.com/t5/Desktop/Multiple-row-headers-in-Matrix-visual/td-p/372306

Custom Visual: https://community.powerbi.com/t5/Desktop/Double-column-headers-on-a-matrix/td-p/368141

If this helps please kudo.

If this solves your problem please accept it as a solution.