Manipulating data from Microsof Form

[kk2018]

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

[v-yulgu-msft]

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

[kk2018]

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?