Bar Chart in Power BI

[Anonymous]

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.

[Anonymous]

[Anonymous · Accepted 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.