Matrix Table how to arrange rows and columns correctly

[Anonymous]

I have the following table in excel and i want to do the same in PowerBI:

i tried to do the same in power bi with matrix table and here's what i got:

 

if i put the Target under Values the result is not like the table in excel, it will give a strange layout here's a shot:

I want to compair the target and actual sales for each month, like the one i made in excel. but the matrix is putting the actual and target next to each other. 

is there a way or a diffrent visual that will help me.

Thanking you all.

[Mariusz · Accepted solution]

Hi @Anonymous 

Sure, Go to Matrix Visuals Format options  > Expand Values section > Toggle "Show on rows" On.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks @Mariusz 

salute

regards