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