Forum Discussion
create matrix with multiple columns data
Hi Anonymous ,
I create a sample pbix file for you, please check if it meets your needs.
Best Regards
Rena
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
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
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
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
i can not see the attachment option here... do u knw how can i send the excel file to you