4 Replies Latest reply on Jul 27, 2018 9:10 AM by swaroop.gantela

# Adding multiple labels to a duel axis donut

Hi there,

I'm running into an issue with a donut chart I created.  It has a contract and not contract break out and I have the % of total for those showing.  What I want to do is add in the total amount as well. However, when I do that both amount display on both sides on the donut.   How do I get the correct amount to display on the correct side?

Thanks,

--Brian

• ###### 1. Re: Adding multiple labels to a duel axis donut

I can't quite tell what you're doing here. Any chance you can attach a packaged workbook?

• ###### 2. Re: Adding multiple labels to a duel axis donut

It seems like it would be pretty simple.   all I want to do is show the contract sum (the 5,595,924) under the 44% of Contract side of the donut and then the 7,187,159 under the 56% non-contract side of the donut instead of each showing under both sides.

• ###### 3. Re: Adding multiple labels to a duel axis donut

The problem is that we don't know anything about your data. Without some better idea of how the data is structured, it's quite difficult for us to help troubleshoot the issue.

My guess is that you're getting both values because you've placed two separate measures on the label card. That will cause that value to show up on both pieces of the donut chart. Unfortunately, I'd need to know more about your data's structure in order to be able give an adequate solution.

• ###### 4. Re: Adding multiple labels to a duel axis donut

Brian,

As Ken described, it is the difficulty of using MeasureName/MeasureValue

because we are not able to create calculated fields using IF [MeasureName]= THEN ...

This workaround is likely to be quite unsatisfactory, but just thought I'd throw it out there.

You could put the total amounts on the Measure Value Shelf as well. Because their size

will swamp out the percentages, yet at the same time keeping the pie proportions the same,

you will get the four individual labels, which you can move around.

There may be some possibilities if your data could be pivoted, but likely that will make

other calculations more tricky.