Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

create matrix with multiple columns data

Hi, i am trying to create the summary table using matrix visualization. the data has multiple KPIs columns with values 0,1 and n/a. i want to create like below - KPI  A  B    C    D     E     F 0     20 22  17  40  12   30 1     7   11  3    14  6     11 n/a  4   2    4     4    5    6 i am able to create table with A,B,C,D,E,F columns with values but i dnt knw how to create first column "KPI" becasue this is common values across all sheet and how to map it.

 

 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    I create a sample pbix file for you, please check if it meets your needs.

    Best Regards

    Rena

12 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

      might be table was not appearing correcting in intial post so sharing the pic if it helps. i am trying to create column 'KPI' need help there on how can i create this column so that column A to F can show values as per 0,1,n/a

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        What's your expected result? Whether the following one is what you want?

        Best Regards

        Rena