Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cbschley
Helper III
Helper III

Custom Tooltip to display items in bucket

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.

 

cbschley_0-1718222282124.png



Ideally the tooltip will look something like this:

cbschley_1-1718222302432.png

 

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?

1 ACCEPTED SOLUTION
cbschley
Helper III
Helper III

@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.

View solution in original post

2 REPLIES 2
cbschley
Helper III
Helper III

@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
Super User
Super User

@cbschley , 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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors