Load data from Microsoft Forms, Rating type question

[Anonymous]

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? 

[amitchandak]

@Anonymous ,

refer if these can help

https://www.youtube.com/watch?v=aXpgUM-dSmI

https://www.tutorialgateway.org/create-100-stacked-bar-chart-in-power-bi/

[Anonymous]

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]

@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?

[Anonymous]

Well I'm experimenting with publishing the data "near real time" so whenever I get a new Forms answer, the visualization gets updated. For this I have found some helpful guides on how to do that using Power Automate, but as I'm new to this area, I'm trying to avoid too complex scenarios.

I think I can manage if all the survey responses are in, but I'm trying to create a visualisation that works as each Forms response get's in.

I'm sure it can be done even automating the steps in Power Query, I'm just not on that level yet when it comes to handling new data that gets updated after I modeled the original data.

I will split the data and read up upon how to handle new data after the modelling.

I guess it's only a question of time before Microsoft enables a native forms integration into Power BI (It may alrady be there, but I have not found it), but until then I'm fiddling with both Power Automate and Power BI to get the needed results. 

Thanks again, much appreciated

[parry2k]

@Anonymous thanks for explaining. There are two separate parts, how the data reaches to the dataset and model/transformation. Once you have done transformation and all your visuals, after that it doesn't matter how data get refreshed, thru power automate, someone manually does it, transformation step is going to run and update the visuals.

Good luck!

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.⚡

[parry2k]

@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]

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