Forum Discussion

Narenthir's avatar
Narenthir
Frequent Visitor
7 months ago
Solved

Help needed

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...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    7 months ago

    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!

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
7 months ago

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's avatar
Narenthir
Frequent Visitor
7 months ago

Hello grazitti_sapna Thanks for the solution. Really appreciate.