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