Reply
Ansicone
Advocate II
Advocate II
Partially syndicated - Outbound

Doughnut chart - total value

Dear all

 

I can't seem to find option to display total (sum of all) values in doughnut chart, i am used to SalesForce total in the middle, i had good look and still don't know how to add it here - in fact this applies to other charts too. Is this, again, by desing?

11 REPLIES 11
joannm
Frequent Visitor

Syndicated - Outbound

One of the MAIN reasons for using a donut chart rather than a pie chart is for the ability to place the total in the center. Seems like a rather big miss for an option on this visual. A simple setting for Show/Hide on the value and the label would suffice. I really grow tired of all the workarounds I have to do in my powerbi workbooks.

 

I guess that what happens when you're basically alone in the Gartner magic quadrant.

Syndicated - Outbound

+1 reason (on thousand others) things that why I miss Qlikview

ShashidharG
Frequent Visitor

Syndicated - Outbound

Hey @Ansicone

 

You can use a card chart on the donut, and it ll appear as if the Total value is fit inside the donut, and lets your tooltip for the donut itself as it gets card to backward scene.

 

 

Donut Card.PNGDonut.PNG

Syndicated - Outbound

This method is not useful to add card inside the dounut chart when sharing the reprot to the service. At clicking the donut chart, this card visual disappears automatically. 

avatar user
Anonymous
Not applicable

Syndicated - Outbound

I have done the same. However the card does not appear when the report is shared with someone.

Am I doing something wrong?? 

Syndicated - Outbound

Cards work great for reports however, they are not included in the dashboard when I "pin visual". Must publish as a full report which means a different look / feel / behavior.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

I find it really weird that adding totals in the middle is not an out of the box option, I cannot believe that would be much work to add... I have been using the card in the middle in the past ass well, but as above already stated this is simply not possible when pinning to a dashboard, which is a core functionality in Power BI.

The only working alternative I found is a custom visual called Ring chart, which is able to add totals and some other stuff.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380824?tab=Overview

avatar user
Anonymous
Not applicable

Syndicated - Outbound

That's a good one, and it's free!

Eric_Zhang
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@Ansicone

 

There's  field called "ToolTips" and many tricks can be played with it. In you case, create a proper measure and apply it to the field.

 

Capture.PNG

 

Ansicone
Advocate II
Advocate II

Syndicated - Outbound

Again, thanks for quick reply. Indeed - this is good workaroud, but totally unusable on the dashboard. Oh well M$.

jahida
Impactful Individual
Impactful Individual

Syndicated - Outbound

I think the standard PowerBI way to display a total here is using a card visual and just sizing it to fit in the middle of the chart. A bit strange, I know, but gets the job done. I believe there's also custom visuals that will do it for you like https://app.powerbi.com/visuals/show/DonutChartGMO1461469098694

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)