Forum Discussion
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:
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 :-(
Thanks for your help! :-)
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.
3 Replies
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:
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.