Forum Discussion

ssjordan95's avatar
ssjordan95
New Member
3 years ago
Solved

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
  • 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)

    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.

    Result:

     

    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.

6 Replies

    • ssjordan95's avatar
      ssjordan95
      New Member

      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
      • wdx223_Daniel's avatar
        wdx223_Daniel
        Community Champion

        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

         

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support

        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)

        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.

        Result:

         

        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.