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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

data tooltip

hey ,

 

My graph shows the amount of films each director has
I want to show Tull Tip the most lucrative film of any director.
I came out with an index that measures the profit of each movie and took the maximum
Instead of showing me the profit I want him to show me the name of the movie
How can I do this?

pbi.png

 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

According to my understand, you want use tooltip to display the film name with the most profit per director ,right?

You could create a measure as shown belows:

The most profitable film =
VAR _max =
    CALCULATE (
        MAX ( 'Table'[Profit] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Director] = MAX ( 'Table'[Director] ) )
    )
RETURN
    CALCULATE ( MAX ( 'Table'[Film] ), FILTER ( 'Table', 'Table'[Profit] = _max ) )

Then drag it to Tooltip pane like this:

10.30.7.1.gif

Here is the pbix file.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards,
Eyelyn Qin

lbendlin
Super User
Super User

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.