@Anonymous you need to unpivot your data. In Power Query, select ID column, right click and then "unpivot other columns", it will get you survey answeres in "value" column for all the question. From this table, it is pretty easy to calculate the % of each answer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous so final result you are looking for is how much each answr have like
agree 10%
often 20%
rarely 30%
..... and so on...
correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous it is easy from here
in table visual, drop "varde" column on table visual twice, and on 2nd varde column, chooise aggregation to "count" and in new quick measure select "% of grand total" as show in image below, you can also achieve this by DAX but this is quicker. Hope it will get your started.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi again @parry2k :-), now it looks like this but we lost which questions the answers are to - Q1a, Q1b etc. Thanks in advance!
@Anonymous you can add "attribute" in the table visual and you will get the question.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous Please try to group your attributes as below and use the groups in the Table Visual
@Anonymous Hello !! This is PattemManohar.... I think you are responding to me but tagging to parry2k. 
Anyway, is this you are trying to achieve...
@Anonymous Ok, then create a Matrix visual and use the "Attribute (Groups)" (That you have grouped as Q1 and Q2), Attribute and the Response fields.
@Anonymous Please click "expand all down one level in hierarchy" Also, if you need responses as well in the matrix then add value to the visual (Response)
@PattemManohar we are almost there but I would like each subquestion to add up to 100%. Now it all adds up to 100%, see below
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
