Tooltip for only one column in table visual

[Anonymous]

Hi,

I have a table visual with a number of text columns and measure columns. This can't be shown as a Matrix. 

I have a custom tooltip which include 3 other measures but is appearing for all the columns, I would like this to only appear when I hover over the column in the table it is related to. 

Is there any way to do it? Can i show different tooltips on different columns? F.e = rows are employees, columns different employee details and then measure columns such as profit and different kpis, i would like to show a tooltip while hovering over profit, and another tooltip while hovering another measure column.

Thanks in advance!

[v-sgandrathi]

Hi @Anonymous,

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-sgandrathi]

Hi @Anonymous,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @Anonymous,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[danextian]

Hi @Anonymous 

Tooltips in a table visual are evaluated per row rather than for a specific column. To filter tooltips by a chosen measure, create a disconnected table containing the measure names, create a measure that returns the desired calculation based on the value of the column and use it to control the tooltip behavior.

Notice that in the image below, the measure in the tooltip changes with the column name.

Please see the attached sample pbix.

[praveenkandi]

This works on Matrix visual not on Table, the issue mentioned is with Table visual I believe, even am looking for the same help. Thanks!

[Anonymous]

Hi, im checking your pbix and could be helpful but doesnt work for my question, first you are using matrix instead of table i think that could be the limitation. I need to show different measures in tooltips.
F.e row 1 employee A:  column 1 - 2 - 3 text i need not to show anything. Column4 profit i want to show month 1 rev measure/month 2 rev measure. Column 5 qty kpi i want to show amount and category. 

As of now i set up a new tooltip page which show me correct profit measures filtered by employee rows but showing same measures for all the columns, i just want to show different kpis in different columns.

Let me know if doesnt make sense. 

Thanks!!

[danextian]

As mentioned in my initial reply, tooltips in a table visual are evaluated row by row. The only closest visual that allows evaluation on both rows and columns is a matrix.

[bhanu_gautam]

@Anonymous , Try using

1. Create a new page named "Profit Tooltip".
2. Design the "Profit Tooltip" page to show the relevant measures and information related to profit.
3. Set the page size to "Tooltip" and turn off the "Page Information" toggle.
4. Go to the "Format" pane, expand "Page Information", and turn on the "Tooltip" toggle.
5. Name the tooltip page "Profit Tooltip".
6. Go back to your main table visual, select the "Profit" column.
7. In the "Visualizations" pane, go to "Values", click on the "Profit" column, and then click on the "Tooltip" icon.
8. In the "Tooltip" settings, select "Report page" and choose "Profit Tooltip".

[Anonymous]

Hi, thanks for the response. By selecting column what do you mean? In a table visual you are not able to select columns i think, just for matrix. By the way i did all the steps but still showing same tooltip for all the columns and lines. Any other approach? Thanks!