cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ssjordan95
New Member

Customizing tool tip for table value

Hello! Upon reading the forum and watching many tutorial videos, I haven't seen any examples for tool tips related to table filtering. I would like to hover over a table value, and have a tool tip to display information tied to that specific value. Currently, I have a tool tip page, tool tips turned on for the page and tool tip table but when I hover over the value on my main page, it shows the entire tool tip page rather than filtering the table based on what value I am hovering over. Given the example below, if I hover over '1', I'd like for the tool tip to only display '1''s from column 1 and the corresponding column 2 values. 

 

Main page

Column 1
1
2
3
4

 

Tool tip page

Column 1Column 2
189
193
146
157
265
289
393
346
457
465

 

Desired outcome

Tool Tip PageColumn 2
189
193
146
157
1 ACCEPTED SOLUTION

Hi, @ssjordan95 

Please try following steps:

1. add a tooltip page (allow use as tooltip page)
(need to turn off 'Keep all filters' and drag the field 'Column1' to the pane as tooltip filed)

veasonfmsft_0-1666256475357.png

Related tutorials:

Create tooltips based on report pages 

2.In main page, select the visual for which you want to specify the manual tooltip, then in the Visualizations pane, select the Format section and expand the Tooltips card.

veasonfmsft_1-1666256940485.png

Result:

veasonfmsft_2-1666257069659.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

@ssjordan95 Can't replicate, see attached PBIX beneath signature. Are you missing a relationship in your model?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler sorry, forgot to tag you 

Hi, @ssjordan95 

Please try following steps:

1. add a tooltip page (allow use as tooltip page)
(need to turn off 'Keep all filters' and drag the field 'Column1' to the pane as tooltip filed)

veasonfmsft_0-1666256475357.png

Related tutorials:

Create tooltips based on report pages 

2.In main page, select the visual for which you want to specify the manual tooltip, then in the Visualizations pane, select the Format section and expand the Tooltips card.

veasonfmsft_1-1666256940485.png

Result:

veasonfmsft_2-1666257069659.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Greg, on the main page, there is actually a table with column 1 and column 2 - my mistake. Seems like the tool tip carries over the filter for both columns from the main page when I'd only like to filter for column 1. Let me expand my example, see below. 

 

Main Page

Column1Column2Column3Column4
1Sam57XI
2Jack85XI
3Jill64LI
4Max56LI
5Lenny26LP
1Jesse15LP
1Sydney43LP
2Spencer56XI
4Frank45XI

 

Tool Tip Page

Column1Column5
1245
2567
3855
4966
54654
1165
1615
2658
4123

 

Desired Outcome if Hovering Over '1'

Column1Column5
1245
1165
1615

 

Full Data Set

Column1Column2Column3Column4Column5
1Sam57XI245
2Jack85XI567
3Jill64LI855
4Max56LI966
5Lenny26LP4654
1Jesse15LP165
1Sydney43LP615
2Spencer56XI658
4Frank45XI123

this is the final outcome

wdx223_Daniel_0-1665382730538.png

the steps are:

1, create a new table

wdx223_Daniel_1-1665382797058.png

2, put the columns of new table in the table viusal of Tool Tips page. and create a new meausre to filter this visual,like this

wdx223_Daniel_2-1665382936484.png

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors