Matrix Visual and visualization

Question

I have a table called ProdInvc which has columns as product name, origin state, destination state, Quantity and amount. and another table which is just State that has State name. I need to make a matrix visual where in first column it is product name and then it should show Qty of each product based on origin and destination state (going across column)

Input

ProdInvc

P.Name	O Origin State	Destination State	Qty	Amount
A	x1	z1	20	200
b	y1	w1	100	1000
c	z1	x1	1000	2000
e	w1	y1	300	2000
f	x1	z1	200	3000
g	y1	w1	43	200
h	z1	x1	200	1000
i	w1	y1	400	4000
j	x1	z1	400	5000
k	y1	z1	300	2000
l	z1	w1	200	3000
m	w1	x1	100	1000
A	y1	y1	1000	1000
b	z1	z1	300	2000
c	w1	w1	200	2000
e	x1	x1	43	3000
f	y1	y1	1000	200
g	y1	z1	300	1000
h	z1	w1	200	4000
i	w1	x1	43	1000
j	x1	y1	200	2000
k	y1	z1	43	2000
l	y1	w1	200	3000
m	z1	x1	400	200
c	w1	y1	400	1000
e	x1	z1	300	4000
f	y1	w1	200	2000

State

x1

y1

z1

w1

Output

If there is any other visual that satisfy the above criteria, I am open to suggestions.

ritaf1983 · Accepted Answer

Hi&nbsp;learner03&nbsp;To get the desired result you should unpivot the states columns with Power query.

Then you can create a matrix like this:

Pbix is attached
If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly

Forum Discussion

Matrix Visual and visualization

2 Replies

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Matrix visual

Formatting Matrix Visuals