Forum Discussion

baobab's avatar
baobab
Regular Visitor
7 years ago

Rankings from Microsoft Forms

Hi,    I made a survey using Microsoft Forms and many of my questions were rankings. However, the results are put into a single cell and are delimited by semicolumns. For instance, in a hypothetica...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi baobab，

 

If I understand your scenario correctly that you have got data from Microsoft Forms in Power BI Desktop and want to create the visual silmilar with the chart you upload with the Ranking of the questions?

 

I'm not familar with Microsoft Forms, if it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

In addition, for your requirement, the conditional formatting may be your choice.

 

Best Regards,

Cherry

baobab's avatar
baobab
Regular Visitor
7 years ago

Hi v-piga-msft, thanks for replying.

 

You understood the scenario correctly. If not the same visual, I'd like at least to plot that data in some kind of chart. Here's the dummy file. I've kept two columns, one with the time to identify each responder and another one with the actual data. 

 

Basically, the ranking from MS Forms is translated into excel in a single cell, with every choiche of the ranking ordered from first to last choice, divided by a semicolumn.  

 

Thank you!