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-5) should be in positive side. 
When i use stacked column chart it show only 0% to 100%.
Please advise

 

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!

3 Replies

  • 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!

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      7 months ago

      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