Stacked column/bar chart tooltip with cumulative sum

[mrothschild]

In both Excel and BI I've created a stacked bar chart from the following data:

Asset	Unlevered Return	Levered Return	Difference
A	10.3%	17.0%	6.7%
B	11.5%	18.3%	6.8%
C	11.5%	18.3%	6.8%
D	9.9%	14.6%	4.8%
E	12.7%	20.7%	8.0%
F	11.4%	18.2%	6.7%
G	8.2%	17.7%	9.5%

The excel output chart looks like this.  

What I'd like is for the tooltip to show the sum of the two data lables without showing the "Difference" data label.  For example the tooltip for column 1/Asset A would show "Unlevered Return = 10.3%" and "Levered Return = 17.0%" and the visual would look the same (absent visible data labels, which I already know how to turn off". 

Saird differently, right now I can get the tooltip to show:

[when I hover over the dark blue]

Unlevered Return = 10.3%

Levered Return = 17.0%

[when I hover over the light blue]

Difference = 6.7%

Levered Return = 17.0%

What I'd like is that no matter which part I hover on the tooltip says:

Unlevered Return = 10.3%

Levered Return = 17.0%

[v-yuta-msft]

@mrothschild ,

You can configure a custom tooltop in your report. For more details, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-custom-tooltips.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mrothschild]

Thanks for responding, but the link doesn't accomplish my objective.  Perhaps there's a work around.

To simplify, let's say my data is this:

Color	M&Ms
Blue	3
Total	7

I want to show a stacked bar/column chart and know that the only other color of candy is red.  So I create a measure

[RED] = [TOTAL] - [BLUE]

Now I have a stacked bar chart that sums to 7, comprised of 3 of Blue and 4 of Red.  

But in the tooltip, I only want to show 3 and 7 and make no reference to the 4.  

When I imply there's a work around, perhaps there's a way to set up the visual such that I don't need to do the intermediary step of creating the 4 for red in the first place?