Forum Discussion
DAX COMMAND
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!
Thank you Syk, you explained everything in detail and your advice helped me too much!