Forum Discussion
Restrict Report page tooltip to one column
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!
