Forum Discussion

R3muS10's avatar
R3muS10
Frequent Visitor
9 years ago
Solved

Matrix columns and rows

Hello. I am new user to power bi.    I tried to make a matrix with some database entries but it seems I can't get this right... I read almost everything about this on the forums and tutorials and ...
Need Help
Tutorial Requests
  • R3muS10's avatar
    R3muS10
    9 years ago

     Anonymous With a little bit of help of your screen shot I managed to make my Matrix visual in Power BI. All I needed to do was to un-pivot some columns in the database query and worked my way around that. I kept using the pivot and I didn't realize what was not working.

     

    dkay84_PowerBI Thank you for this tip. I created the columns ( Attributes & Values ) with the unpivot columns.

     

    Thank you for the help that you provided :) .

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi R3muS10,

How do you store data in your original table? It is easy to create a Matrix visual in Power BI Desktop if you have sample data shown in the following scrrenshot.




Thanks,
Lydia Zhang

R3muS10's avatar
R3muS10
Frequent Visitor
9 years ago

 Anonymous With a little bit of help of your screen shot I managed to make my Matrix visual in Power BI. All I needed to do was to un-pivot some columns in the database query and worked my way around that. I kept using the pivot and I didn't realize what was not working.

 

dkay84_PowerBI Thank you for this tip. I created the columns ( Attributes & Values ) with the unpivot columns.

 

Thank you for the help that you provided :) .