Forum Discussion

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Pie chart not displaying as expected

I am trying to show a pie chart for example i have a value of 61.92% and i want the rest of the percentage (38.08%) upto 100% to be a different colour. How can I achieve this. I have filtered by a sales person. 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    From Appsorce you can download "Circular Gauge by MAC Software" Visual from Marketplace.

    Add visual to your powerbi desktop.

    Set values in Fields Panel>>  Actual value >> Percentage column

                          Target Value >> PercentageColumn>>right click on this field set Show Value as >>% of Grand Total

    Format Panel>>

    Change the color from General section.

    Disable Donut Chart option from panel.

    Refer below screenshot for detailed information.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    From Appsorce you can download "Circular Gauge by MAC Software" Visual from Marketplace.

    Add visual to your powerbi desktop.

    Set values in Fields Panel>>  Actual value >> Percentage column

                          Target Value >> PercentageColumn>>right click on this field set Show Value as >>% of Grand Total

    Format Panel>>

    Change the color from General section.

    Disable Donut Chart option from panel.

    Refer below screenshot for detailed information.

    • akhaliq7's avatar
      akhaliq7
      Icon for Post Prodigy rankPost Prodigy

      Thanks one of the best recommendations I have had since using power bi community. The chart looks amazing and it works.

  • akhaliq7 , what I feel you are using  a % measure and there is filter because I can100% from pie

     

    Please check for that.

     

    or

    Can you share a sample pbix after removing sensitive data.

    • akhaliq7's avatar
      akhaliq7
      Icon for Post Prodigy rankPost Prodigy

      Hi yes I am using percentage measure and the filter is for one sales person, Sorry cannot share pbix file as everything in it is for work. 

      • akhaliq7's avatar
        akhaliq7
        Icon for Post Prodigy rankPost Prodigy

        I can use a card and table visuals but looking for options for other kinds of visuals