Custom Tooltip to display items in bucket

[Anonymous]

Hello community!

I am trying to create a custom tooltip that will display the locations that make up the individual bars in this stacked-bar chart. The stacked-bar chart contains 3 measures, one for red, one for yellow, and one for green.

For example, the red bar has 7 items, and I want to display those names in the tooltip that make up the red bucket.

Ideally the tooltip will look something like this:

The tooltip should change based on if the user is hovering over red, yellow, or green. What measures should I be using to accomplish this?

[Anonymous · Accepted solution]

@amitchandak calculation group did not help, however you did give me the idea to convert this to a single measure, and having a category for each of the bars. This allowed me to pass through the location names properly on each bar.

[amitchandak]

@Anonymous , if the measure is used to create a stack, they can not pass as value to filter the data on the tooltip, You need to create a calculation group of measure use that in visual, now of the report tooltip which you can change measure based on selected measure on stacked 

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

Learn Power BI: Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0