Forum Discussion
Matrix
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
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.
2 Replies
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.
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.
