topic Re: Customizing tool tip for table value in DAX Commands and Tips

Customizing tool tip for table value

ssjordan95 — Sun, 09 Oct 2022 14:41:20 GMT

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

Tool tip page

Column 1	Column 2
1	89
1	93
1	46
1	57
2	65
2	89
3	93
3	46
4	57
4	65

Desired outcome

Tool Tip Page	Column 2
1	89
1	93
1	46
1	57

Re: Customizing tool tip for table value

Greg_Deckler — Sun, 09 Oct 2022 14:46:20 GMT

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

Re: Customizing tool tip for table value

ssjordan95 — Sun, 09 Oct 2022 15:14:19 GMT

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

Column1	Column2	Column3	Column4
1	Sam	57	XI
2	Jack	85	XI
3	Jill	64	LI
4	Max	56	LI
5	Lenny	26	LP
1	Jesse	15	LP
1	Sydney	43	LP
2	Spencer	56	XI
4	Frank	45	XI

Tool Tip Page

Column1	Column5
1	245
2	567
3	855
4	966
5	4654
1	165
1	615
2	658
4	123

Desired Outcome if Hovering Over '1'

Column1	Column5
1	245
1	165
1	615

Full Data Set

Column1	Column2	Column3	Column4	Column5
1	Sam	57	XI	245
2	Jack	85	XI	567
3	Jill	64	LI	855
4	Max	56	LI	966
5	Lenny	26	LP	4654
1	Jesse	15	LP	165
1	Sydney	43	LP	615
2	Spencer	56	XI	658
4	Frank	45	XI	123

Re: Customizing tool tip for table value

ssjordan95 — Mon, 10 Oct 2022 03:20:20 GMT

Greg_Deckler sorry, forgot to tag you

Re: Customizing tool tip for table value

wdx223_Daniel — Mon, 10 Oct 2022 06:22:33 GMT

this is the final outcome

the steps are:

1, create a new table

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

Re: Customizing tool tip for table value

v-easonf-msft — Thu, 20 Oct 2022 09:11:56 GMT

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)

Re: Customizing tool tip for table value

hsantosh — Fri, 23 Feb 2024 16:16:01 GMT

Is there anyway to display tooltip when hover on LP only from column 4.