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.
Hi All,
I'm new to PBI, and am hoping you can help me. I am visualizing data from a satisfaction survey, and am having issues with a stacked bar chart.
My data consists of 14 questions with values on a 5-point scale. Each question is a column, and each survey is a row.
I need to have a stacked bar chart that shows how many people responded with each of the five points, so each stack would include:
The final result something like this:
I've tried using text values and creating COUNTROW measures for each value per question. I've tried using numeric values and working with the data that way. No matter what, all the data just stacks up in one bar, or if I move my data to the Axis section, I get no bars. I've been searching Google and the Power BI site, but I'm not finding instructions for what I'm sure is a pretty basic action.
Help? Please? 🙂 Thanks in advance - I really appreciate it.
Solved! Go to Solution.
If you survey table is like below. You can select all columns in this table and click Unpivot Columns in Query Editor.
With above transformed table, we can use the 100% Stacked bar chart to get the expected report.
Best Regards,
Herbert
If you survey table is like below. You can select all columns in this table and click Unpivot Columns in Query Editor.
With above transformed table, we can use the 100% Stacked bar chart to get the expected report.
Best Regards,
Herbert
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |