Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Visualisation of Real Time Data through Forms

Hi. I have tried looking for the answer everywhere but still do not know what I am doing incorrectly.

 

I have created a survey through Microsoft Forms that respondents will answer. I am hoping to use BI to visualise the real time data, I have managed to follow a few tutorials and have been able to connect real time data in Microsoft Forms using Flow.

 

The issue is that some of the fields are not appearing as they should when I am trying to present them through Visualisations. I have found that most of the examples are when the fields are based of questions with 'multiple check boxes'. 

 

For example: the question I have asked is  (this is just as an example), what is your favourite icecream flavour? 

The options given were: chocolate, vanilla and strawberry. 

 

Because some respondents have ticked more than one box, I am getting responses which state: "Chocolate", "Vanilla".

 

Is there a way to visualise the data to show that x amount of people selected Chocolate, x amount of people selected Vanilla etc? 

 

Through Microsoft Flows, I have simply listed the question as dynamic content. Is there more that I would be required to do? 

 

Your help is greatly appreciated.

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

I have a sample table like this.

v-lionel-msft_0-1597911033740.png

1. 

v-lionel-msft_1-1597911074252.png

2.Unpivot the column

3. Remove the useless column.

4. Create a measure.

Number of selection = COUNT(Sheet6[Value]) 

v-lionel-msft_2-1597911166025.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@Anonymous ,Can you share sample data and sample output in table format?

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

This is currently being used as real-time data, so I have created my own data set in BI.  Have selected the 'streaming dataset' option. Does that make sense?

@Anonymous , I am not clear on the problem you are facing. In case you want to write back. refer -https://www.youtube.com/watch?v=LxuRzj0X348

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak thanks for your help. I have atached my question here. As you can see, when I visualise it in a table, these are the response I get. When visualised in a bar graph it has put the responses together (so if a respondent has mentioned a stress being physical/mental, it has put them together. I would like one bar (section) for each stressor. So the graph will show that 2 respondents have selected physical health, 2 respondents have chosen family for e.g.

 

Capture.PNG

Hi @Anonymous ,

 

I have a sample table like this.

v-lionel-msft_0-1597911033740.png

1. 

v-lionel-msft_1-1597911074252.png

2.Unpivot the column

3. Remove the useless column.

4. Create a measure.

Number of selection = COUNT(Sheet6[Value]) 

v-lionel-msft_2-1597911166025.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.