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.
As always I have tried and tried and tried to post tables and images and I keep getting this error repeatedly without any explanation. "Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied."
Therefore the question is in the first reply to this post. Thanks.
Solved! Go to Solution.
I don't think you can create the exact chart in powerbi ( with X axis 100% both side.)
Use 100% stacked bar chart to get a somewhat similart chart and possibly more desirable.
Get the table in powerbi via get data or copy/past (1st april column you can leave out).
Select all columns and unpivot columns--> you will get 2 columns, 1 with the questions and 1 with results.
Use this to create the the 100% stacked bar chart from the visualisation pane --> questions on the Y axis and count of values (answers) on the X axis. Add values as legend to see the answers as legend.
I don't think you can create the exact chart in powerbi ( with X axis 100% both side.)
Use 100% stacked bar chart to get a somewhat similart chart and possibly more desirable.
Get the table in powerbi via get data or copy/past (1st april column you can leave out).
Select all columns and unpivot columns--> you will get 2 columns, 1 with the questions and 1 with results.
Use this to create the the 100% stacked bar chart from the visualisation pane --> questions on the Y axis and count of values (answers) on the X axis. Add values as legend to see the answers as legend.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |