create matrix with multiple columns data

[Anonymous]

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     20 22  17  40  12   30 1     7   11  3    14  6     11 n/a  4   2    4     4    5    6 i am able to create table with A,B,C,D,E,F columns with values but i dnt knw how to create first column "KPI" becasue this is common values across all sheet and how to map it.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

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

[v-yiruan-msft]

Hi @Anonymous ,

What's your expected result? Whether the following one is what you want?

Best Regards

Rena

[Anonymous]

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

[v-yiruan-msft]

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]

 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 

[v-yiruan-msft]

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]

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

[v-yiruan-msft]

Hi @Anonymous ,

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

Best Regards

Rena

[Anonymous]

Hi @v-yiruan-msft ,

i am facing issue there in onedrive so sharing the data in google doc . i am actually looking for 2 visuals which i created in the google doc with just example data.

https://docs.google.com/spreadsheets/d/1rB9nbYQYgh9HDWlBRn9XrsYFan_0xyMmVCHNrJUUENk/edit?usp=sharing...

visual 1 -  showing the KPI count as per 1,0,n/a values

Visual 2 - showing KPI data in table for brand/market which should get updated as per KPI selection. its being difficult for me on how to create the KPI filter. i am able to create the table per KPI but not sure how should i create where all KPI data can be showing on checkbox selection.

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

I create a sample pbix file for you, please check if it meets your needs.

Best Regards

Rena

[Anonymous]

This is awesome , such a simple solution.  thanks a lot @v-yiruan-msft