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    ...
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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        i am having excel data with multiple columns (like A-G) and 100 of rows. each column has values in the form of 0 ,1,n/a 

        i am trying to create the matrix view to show the count of 0 , 1 and n/a for these columns