Help needed

[Narenthir]

How to create a visual exactky like in the picture from the microsoft forms survey
I connected the data to my power bi.
Want to show Rating from (1-2) should be on negative side, 3 in middle and (4-5) should be in positive side. 
When i use stacked column chart it show only 0% to 100%.
Please advise

[grazitti_sapna · Accepted solution]

Hi @Narenthir,

I've created the sample .pbix file for you, I've created two visuals one using the rating (1,2,3,4,5) another one is using the grouping (1-2,3,4-5), Please see attached file.

Steps performed.

1. Created a rating group column to acheive the rating group

2. Created ariuos measures to achieve final diverging % measure

3. Created stacked chart visual as below 

Field	Value
Y Axis	Question
Legend	Rating Group
Values	Diverging %

Set X- axis 

Minimum = -1

Maximum = 1

Then selected the coulour from bars option.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[Narenthir]

Hello @grazitti_sapna Thanks for the solution. Really appreciate.

[v-menakakota]

Hi @Narenthir ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @grazitti_sapna  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team