Forum Discussion
Dynamic tooltip with dynamic value for row level detail
Hello,
Unfortunately, I cannot share data for privacy reasons. I am building out a tooltip that dynamically shows values from columns for each specific row.
The data table contains the following information:
| Person | Field1 | Field2 (numeric) | Field3 (numeric) |
| A1 | Alpha | 1 | 3 |
| B1 | Beta | 2 | 4 |
I have placed the Person and Field1 columns in a matrix. My expected visual is such that when I hover over "Alpha" for Person "A1", the tooltip would show:
Person: A1
Field1: Alpha
Field2: 1
Field3: 3
However, when using the dynamic value tool, it does not generate the desired calculatation. I can produce the MIN, MAX, or Total but not the distinct value at that row.
Any suggestions?
Thanks so much!
Add these measures to your matrix Tooltips:
Field2 Value = SELECTEDVALUE(Table[Field2])
Field3 Value = SELECTEDVALUE(Table[Field3])Then create a report page tooltip page with a table/matrix showing Person, Field1, Field2 Value, Field3 Value. Set page size to Tooltip size.
Drag measures to tooltip bucket.
3 Replies
- Kedar_Pande
Super User
Add these measures to your matrix Tooltips:
Field2 Value = SELECTEDVALUE(Table[Field2])
Field3 Value = SELECTEDVALUE(Table[Field3])Then create a report page tooltip page with a table/matrix showing Person, Field1, Field2 Value, Field3 Value. Set page size to Tooltip size.
Drag measures to tooltip bucket.
hello,
your requirement can be achieved just by using page tooltips.
First, create a new page and put the detailed table you need, without any filters.
Then, in the page settings of this page, check the option to use as a tooltip.
Finally, wherever you need the hover functionality, find the tooltip in the general tab, and it will automatically switch to the specific page.
- danextian
Hi rsanchez
If this is a table visual, tooltips are evaluated at the row level rather than the individual cell level. A tooltip that reacts to the specific cell being hovered can only be achieved by using a matrix visual, and even then it requires some workaround.
Please provide a workable sample dataset (not an image), along with the expected result using that same dataset and an explanation of the logic behind it. You may share an Excel file or a sanitized copy of the PBIX stored in the cloud.
The sample data does not need to contain confidential information, but it should closely resemble the structure of the real data. Creating such a dataset may take some effort, but developing a solution also requires time. Providing a clear sample helps others assist more effectively.
