Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I'm fairly new in create a report in Power BI, I have here sample data for the survey results here (this is how it also looks like in the Sharepoint List where the answers are submitted via Power Apps):
I wanted to make it look like this where it will group the following responses and calculate the percentage:
Favorable = Agree and Strongly Agree
Neutral = Neutral and I Don’t know
Unfavorable = Disagree and Strongly Disagree
And also each category is of separate data sources.
Hi,
Were you able to check the sample data I have provided?
It's just like this where the columns are the questions and the values are the answers. The "Title" is the display name of the user.
So we have other data that are like this but with different questions. Let me know if you need other details.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 38 | |
| 36 | |
| 29 | |
| 28 |
| User | Count |
|---|---|
| 126 | |
| 88 | |
| 78 | |
| 66 | |
| 65 |