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
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
Hi Anonymous ,
What's your expected result? Whether the following one is what you want?
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