Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
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
Hi @Anonymous ,
You can upload the related files to OneDrive for business, then share that link with me. Thank you.
Best Regards
Rena
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.
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.
Hi @Anonymous ,
I create a sample pbix file for you, please check if it meets your needs.
Best Regards
Rena
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |