Forum Discussion
Continued ContributorStacked column/bar chart tooltip with cumulative sum
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%
2 Replies
v-yuta-msftCommunity Support
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.
mrothschildThanks 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?