I can't quite tell what you're doing here. Any chance you can attach a packaged workbook?
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.
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.
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.
Please see workbook v10.3 attached in the Forum Thread.
276802pie.twbx 1.2 MB