Forum Discussion
vejas
Helper I
Helper IMatrix
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: ...
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.
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.