Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Load data from Microsoft Forms, Rating type question

Hi.

 

I created a form with dummy data to test how i can visualize the various question types in Microsoft Forms.

 

The Question type "Ratings" has this great build-in visual:

When I import the data into Power BI Desktop it's in this format: "Sushi;Tacos;Hamburger;Tacos;Kebab;".

I understand that if I in Power Query split the data into 5 columns I could create something similar, but is there a way I can keep the data in a single column and visualize the data the same way as Forms does natively? 

Need Help
Tutorial Requests

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous better is to split into rows not even in columns, and then it is much easier to produce the output, you cannot use without splitting.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks parry2k . Sorry ment rows, long day.....

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks amitchandak .

       

      Did try that, but then the data looks like this:

      I'm fairly new to Power BI, so my apoligies if this seems simple to you, but I could not find a standard visual that generates the same look as the one in Forms.

       

      As parry2k noted I can achieve it by splitting into seperate rows, I was just wondering if there was a method in which I could get the same result without splitting the data

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous spitting is your friend, end of the day everything is based on the good data model and splitting into rows is a good model. Question is why you don't want to split? What is the reservation? Why do you want to work from a single column? What business goal you are trying to achieve keeping the values in one column?