Forum Discussion
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 I couldn't get anything to work.
As the picture above is showing (a "matrix" created in Excel) I need to create some rows that are stored in the database with the names showed there and on columns I have some city names that I need to be stored there.
How can I create this on a matrix visualization ? Any tips on how can I do it are deeply appreciated.
Thanks in advance.
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 :) .
3 Replies
Using the Matrix visualization in Power BI, you would put City Names in columns, value fields (i.e. salary, salaryworked, etc.) in the values option, and possibly need to create a new column with the names of your value fields which you would add to the rows option.
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 ZhangAnonymous 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 :) .
