Creating a diverging bar chart to show sentiment

[Anonymous]

I am trying to create a diverging bar chart very similar to this post here: https://community.powerbi.com/t5/Desktop/Creating-a-diverging-stacked-bar-chart-to-show-sentiment/m-...

@parry2k 

However, I am not only dealing with two variables (positive vs. negative) but four (Agree, Disagree, Neutral, and Blank values). In the end, I want it to look like this chart:

 

This would come from three different columns of data. Here is an example of what the data would look like:

Ideally, I wouldn't want to include the blank responses in the total %, but I also don't want to filter out the entire row of data as there are still data in the other columns I would like to include.

I am still very fresh to Power BI and cannot find an easy way to do this. It all seems very complicated, and any help would be appreciated! 

[SeanNorton]

Hi, I'm also trying to create diverging stacked bar charts that are centered over the neutral midpoint. I've been able to do this quite nicely in Tableau, but I'm being forced to switch to Power Bi at work. I'm new to Power Bi, so any help you can provide would be greatly appreciated. I typically work with 5- to 7-point Likert scales, and having charts that are ordered and stack over the middle of the neutral midpoint is a really slick way to showcase the results. Thank you! 

[Anonymous · Accepted solution]

@Anonymous 
With 4 variables, you could use a Switch() or Nested IF() to include the 4 values rather than just:

 IF ( SELECTEDVALUE( 'Table'[Sentiment] ) = "Negative", -1, 1 )

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.