Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix Table how to arrange rows and columns correctly

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.

  • 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

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    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