Forum Discussion
Restrict Report page tooltip to one column
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,
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.
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.
Thanks for this!
It works but only if you set the tooltip column to "Summarized"
Anonymous I did not get it working on a table visual, even when I set the tooltip column to "Summarized"
Hi, thanks for asking.
Sorry for the late reply - I was on vacation.
Did you manage to get id running or do you need help?
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
I could only get it to work with matrix visual.
Cant you switch to that?
Unfortunately I cannot switch to Matrix visual in my case.
Thanks for your help!
Thanks for this!!
This is one of the best features that I add into my reports.
I like to add a custom magnifying glass icon to my report in a "Details" column, so users hover over the magnifying glass in the given row and the entire drillthrough pops up on the screen. This is a giant help to keeping the users on the same page throughout, and not having to keep navigating back and forth reloading web pages -- bc without this method, they would have to keep navving to + clicking the drillthrough button <-- then go back.
Thank you for solution, you made it possible for me.
