Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating a diverging bar chart to show sentiment

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-p/1016209#M480507 parr...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.
     

SeanNorton's avatar
SeanNorton
New Member
2 years ago

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!