Forum Discussion

KristenMackey's avatar
KristenMackey
Frequent Visitor
8 years ago
Solved

Matrix automatically summing columns

Hi All, I am trying to create a matrix in excel using multiple different tables with percentages, but when I put them into the table they are all showing the same value for each row. For example the...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago
    KristenMackey wrote:

     

    I am trying to create a matrix in excel using multiple different tables with percentages, but when I put them into the table they are all showing the same value for each row. For example the rows I am using are:

    And the data I am trying to put into the table is:

     

     

     



    KristenMackey,

    Based on the above sample data, you can directly use Letter field to create relationship among the four tables, then create a table visual to get expected result in Power BI Desktop.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago
KristenMackey wrote:

 

I am trying to create a matrix in excel using multiple different tables with percentages, but when I put them into the table they are all showing the same value for each row. For example the rows I am using are:

And the data I am trying to put into the table is:

 

 

 



KristenMackey,

Based on the above sample data, you can directly use Letter field to create relationship among the four tables, then create a table visual to get expected result in Power BI Desktop.


Regards,
Lydia