Manipulating data from Microsof Form

kk2018 · ‎09-20-2018

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 · ‎09-21-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kk2018 · ‎09-21-2018

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?