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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 So the below screen shot is your expect result and the data marked with red circle is the count of KPI value(0,1 or N/A) per column(A-G)? Could you please provide the source data in excel file?

If your source data is similar with table 1 in below screen shot, you can unpivot the columns A-F first. Then drag the fields onto Matrix visual( Rows: Value  Columns: Attribute  Values: Count of Value).

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 not sure how to create first column with 0,1,n/a to show count  

i am attaching the picture as file attached options is not available here 

 

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Could you please provide your excel file or sample PBIX file? Later we can help create the matrix based on your provided information. Thank you.

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      i can not see the attachment option here... do u knw how can i send the excel file to you

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        You can upload the related files to OneDrive for business, then share that link with me. Thank you.

        Best Regards

        Rena