Pie chart not displaying as expected

[akhaliq7]

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 · Accepted solution]

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]

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

[amitchandak]

@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]

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]

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