Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! 🙂
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI'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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |