I have data in excel as shown below.
C1_1 C1_2 C1_3 C1_4 C1_5
| Affordable | Affordable | Do not know | Do not know | Affordable |
| Affordable | Affordable | Do not know | Do not know | Do not know |
| Affordable | Affordable | Do not know | Affordable | Affordable |
| Affordable | Affordable | Do not know | Do not know | Affordable |
| Not affordable | Not affordable | Do not know | Do not know | Not affordable |
| Affordable | Do not know | Affordable | Affordable | Affordable |
| Affordable | Do not know | Do not know | Do not know | Affordable |
| Affordable | Do not know | Not affordable | Do not know | Do not know |
| Affordable | Affordable | Do not know | Do not know | Do not know |
| Affordable | Do not know | Do not know | Do not know | Do not know |
| Affordable | Affordable | Do not know | Do not know | Do not know |
| Affordable | Affordable | Do not know | Do not know | Do not know |
And I want to get visualization in Power BI as shown below. I do not know which measures I have to use to get this kind of table in Power BI. If anyone knows please help. Thanks in advance!
Once you load your data, click "transform data" to bring up your power query window.
Once that window opens, select all of your columns and then under the transform tab, click unpivot columns
This should give you a table with 2 columns - Attribute and Value (see screenshot using your example data)
Close and apply these changes.
Add a matrix visualization to your canvas, add the Attribute field to Rows and Value to columns
Then add your Attribute field to the values. (It should change to "First Attribute" because it is a text field) click the arrow next to it and select "Count" instead of "First".
Then select the same arrow and under "Show value as" select "Percent of row total" for your use case. Then remove the totals from the matrix and you should have what you need!
Once you load your data, click "transform data" to bring up your power query window.
Once that window opens, select all of your columns and then under the transform tab, click unpivot columns
This should give you a table with 2 columns - Attribute and Value (see screenshot using your example data)
Close and apply these changes.
Add a matrix visualization to your canvas, add the Attribute field to Rows and Value to columns
Then add your Attribute field to the values. (It should change to "First Attribute" because it is a text field) click the arrow next to it and select "Count" instead of "First".
Then select the same arrow and under "Show value as" select "Percent of row total" for your use case. Then remove the totals from the matrix and you should have what you need!
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
