Restrict Report page tooltip to one column

[gjadal]

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 the columns. Currently it shows for all cells and is very annoying for user when the tooltip is always there when mouse is moved over the cells.

How can I restrict it to one column?

[Anonymous]

Hi All, 

One Simple workaround is there but it may lead to loose some existing functionality of table visual . Just place textbox or any shape with 100% transparency in the table area where you don’t require report page tooltip. Not recommended solution but can ease some work in case you are displaying huge number of columns in table visual.
this workaround will disable click and scroll functionality in table visual where textbox is placed , remaining place will work as it is since we are just adding text box in certain area of table visual .

I hope Microsoft will definitely release column specific tooltip property for Table visual in coming release.

Thanks

[Anonymous]

HI @gjadal 

One Simple workaround is there but it may lead to loose some existing functionality of table visual . Just place textbox or any shape with 100% transparency in the table area where you don’t require report page tooltip. Not recommended solution but can ease some work in case you are displaying huge number of columns in table visual.
this workaround will disable click and scroll functionality in table visual where textbox is placed , remaining place will work as it is since we are just adding text box in certain area of table visual .

I hope Microsoft will definitely release column specific tooltip property for Table visual in coming release.

Thanks

[Greg_Deckler]

There might be something ticky that you can do but I am not aware of any way to make that happen easily. 

[Anonymous]

Hi @Greg_Deckler 
Is there any other way to achieve this?

Thanks & Regards,

Sai

[gjadal]

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

[Cavs]

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]

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.

[maibacherstr]

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.

[kleighton]

Thanks for this!!

[Anonymous]

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]

Thanks for this!

[Anonymous]

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

[PowerBI101]

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

[Anonymous]

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?

[PowerBI101]

I did not get it running on a table visualization. I had to change my visualization to matrix, then I was able to restrict the tooltip to only one column.

[mike_honey]

This method seems very limited - the tooltip appears for all the fields specified in the Values well of the Matrix.  It only reverts to the default Tooltip for the fields specified in the Rows and Columns wells. 

So it seems only useful if your requirements are limited to one field in Values. 

[Anonymous]

HI @mike_honey 

One Simple workaround is there but it may lead to loose some existing functionality of table visual . Just place textbox or any shape with 100% transparency in the table area where you don’t require report page tooltip. Not recommended solution but can ease some work in case you are displaying huge number of columns in table visual.
this workaround will disable click and scroll functionality in table visual where textbox is placed , remaining place will work as it is since we are just adding text box in certain area of table visual .

I hope Microsoft will definitely release column specific tooltip property for Table visual in coming release.

Thanks

[Anonymous]

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]

I could only get it to work with matrix visual.

Cant you switch to that?

[Anonymous]

Unfortunately I cannot switch to Matrix visual in my case.
Thanks for your help!