Forum Discussion

gjadal's avatar
gjadal
Microsoft Employee
7 years ago

Restrict Report page tooltip to one column

I have a table matrix visual. I have set the tooltip as a report page. The tooltip shows up correctly when i hover over any cell in the matrix. However I want to show the tooltip only for one of th...
Need Help
gjadal's avatar
gjadal
Microsoft Employee
7 years ago

I was able to achieve this by setting the Tooltip to the column name in the page that contained the tooltip

Cavs's avatar
Cavs
New Member
7 years ago

Hi would you mind sending me step by step instructions on how you did it. I don't see any options on how you restrict a tooltip to one column in a table.

 

Thanks,

  • gjadal's avatar
    gjadal
    Microsoft Employee
    7 years ago

    1. Create the main report page with the table matrix visual and lets say you have three columns Date, MonthlyValue, LifetimeValue on it. I want the popup tooltip to show only on MonthlyValue column.

    2. Create a second report page with the popup you want to see. In my case i added a chart on this page using date as x axis and the MonthlyValue as Y-axis

    3. On the second report page,

         a. go to page properties -> Page information and turn on tooltip

         b. On the fields tab, look for TOOLTIP. Drag the MonthlyValue column into it.

    4. On the first report page, select the table visual turn on tooltip and select ReportPage, Page = Auto

    Thats it. The Popup chart created on second report page will show up only for the Monthly value column.

    Hope this helps.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Bonus:

       

      With this "Auto" tooltip page setting you still have an mouseover for the other columns. It is a standard mousover and usually won't be a problem. If you want to get rid of this as well do following:

       

      If you set the transparency in the tooltip settings of the table matrix to 100 %, the tooltip for all other columns disapear. I think this is quite a cool approach to display the tooltip for one column of a matrix table only.

       

      • kleighton's avatar
        kleighton
        Helper II
        3 years ago

        Thanks for this!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It works but only if you set the tooltip column to "Summarized"

      • PowerBI101's avatar
        PowerBI101
        Frequent Visitor
        6 years ago

        Anonymous I did not get it working on a table visual, even when I set the tooltip column to "Summarized"

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi gjadal 

      Thanks for your response. It works fine for the Matrix visual. However, in my case I'm trying to achieve this for the Table visual which isn't working.
      In the below screenshot, I want to restrict the tooltip (last name) to only First Name column. (pbix file attached)

      Do you have any workaround for the Table visual?
      Sample Power BI File

      Thanks in Advance!

       

      Sai

      • gjadal's avatar
        gjadal
        Microsoft Employee
        7 years ago

        I could only get it to work with matrix visual.

        Cant you switch to that?