cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JWorthy Regular Visitor
Regular Visitor

Creating a survey visual

Hello!

 

I'm very new to PowerBi, I'm running throught the tutorial videos but I couldn't see anything to help me with the below.

 

I'm trying to represent some survey feedback as a visual:

- There are 5 questions in the survey

- Each question has a different number of possible responses

- Instances is the number of times a person selected a response to a specific question.

 

How do I represent this information as a nice visual - possilby a stacked column chart

 

The data is below:

Helpline survey Data.JPG

 

I've tried to create a stacked column chart, as below, but it's not working correctly. I had planned:

- Questions on the x axis

- Instances on the y axis

- Colour of the column segments denotes response.

- Size of the coloured column segments shows number of instances for that response.

 

How would I create this?

 

My failed attempt below 😞

 

Helpline survey sort of what I want.JPG

 

Thanks for your help! 🙂

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Creating a survey visual

Hi @JWorthy,

 

Based on the image and the data you show you need to place:

 

Axis - Question

Value - Instances

Legend - Response

 

Should work as you want.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

JWorthy Regular Visitor
Regular Visitor

Re: Creating a survey visual

I've realised what the problem was.

 

The data type was ABC 123. When I changed it to just number it stoped making the values a 'Count'

 

Thanks for your help.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Creating a survey visual

Hi @JWorthy,

 

Based on the image and the data you show you need to place:

 

Axis - Question

Value - Instances

Legend - Response

 

Should work as you want.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

JWorthy Regular Visitor
Regular Visitor

Re: Creating a survey visual

Hi @MFelix,

 

Thanks for your help.

 

When i set the axis, legend and values as you suggest I get each of the coloured segments as 1 unit large each, why is this happening? Is it something to do with 'Instances' being 'count of instances' when I place it under values? If so, how do I change this?

 

This is what happened:

Helpline survey problem 2.JPG

JWorthy Regular Visitor
Regular Visitor

Re: Creating a survey visual

I've realised what the problem was.

 

The data type was ABC 123. When I changed it to just number it stoped making the values a 'Count'

 

Thanks for your help.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 206 members 1,983 guests
Please welcome our newest community members: