cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gjadal Member
Member

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 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?

8 REPLIES 8
Super User
Super User

Re: Restrict Report page tooltip to one column

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


saeruva Regular Visitor
Regular Visitor

Re: Restrict Report page tooltip to one column

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

 

Thanks & Regards,

Sai

gjadal Member
Member

Re: Restrict Report page tooltip to one column

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

Cavs Occasional Visitor
Occasional Visitor

Re: 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,

gjadal Member
Member

Re: 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.

 

saeruva Regular Visitor
Regular Visitor

Re: Restrict Report page tooltip to one column

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)
TooltipRestriction.JPG
Do you have any workaround for the Table visual?
Sample Power BI File


Thanks in Advance!

 

Sai

gjadal Member
Member

Re: Restrict Report page tooltip to one column

I could only get it to work with matrix visual.

Cant you switch to that?

saeruva Regular Visitor
Regular Visitor

Re: Restrict Report page tooltip to one column

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