Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
akhaliq7
Continued Contributor
Continued Contributor

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. 

error3.PNG

1 ACCEPTED SOLUTION
vaishnaviudan
Resolver I
Resolver I

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.

PieChart.PNGFieldsPanel.PNG

View solution in original post

5 REPLIES 5
vaishnaviudan
Resolver I
Resolver I

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.

PieChart.PNGFieldsPanel.PNG

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

amitchandak
Super User
Super User

@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
Continued Contributor
Continued Contributor

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
Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.