This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi,
So I have created a Microsoft form with likert questions. I want the answers to be displayed on power BI with the counts of how many chose 'beginner', 'intermediate','advanced' and 'expert' in graphs or charts for the many different questions. How do I do this?
thanks
Hi @kk2018,
You can export the user response data stored in Microsoft From to Excel file. Then, connect to this Excel file in desktop.
For more advice, please post sample data of the exported excel file and show us the desired output.
Best regards,
Yuliana Gu
Thank you for your response.
I want to be able to make graphs showing how many of each skill (technical writing, presentation skill etc) chose which skill level (beginner, intermediate etc) in graphs and charts on power bi. I want to do this on the online app of power bi because I want the form to be regularly updated. How can I use power BI to count how many of each skill level there is?
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 14 | |
| 10 | |
| 9 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 33 | |
| 28 | |
| 26 | |
| 19 | |
| 16 |