Forum Discussion
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
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.
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.
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
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.
Again, thanks for quick reply. Indeed - this is good workaroud, but totally unusable on the dashboard. Oh well M$.
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.
+1 reason (on thousand others) things that why I miss Qlikview
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
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.
