Forum Discussion

pang22's avatar
pang22
Icon for Helper III rankHelper III
2 years ago
Solved

Power Matrix output

Hello,

 

I have excel data with two factories, can Power BI matrix display the output as second photo?

How to drag the field in Power BI?

 

Original Excel data: 

 

Desired out in Power BI matrix:

 

 

 

 

Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    pang22 

    Basically, you need to show your measures on the row, to achieve that, turnon "Switch Values to Rows"


     

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    pang22 

    Basically, you need to show your measures on the row, to achieve that, turnon "Switch Values to Rows"


     

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Hi pang22 ,

     

    Hi

    Add Factory to Row, Date to column and Order and Capacity to Values. In Visual pane, disable stepped layout and turn on switch values to rows. Please screenshots below.