Forum Discussion
How to create tooltip for table visual?
Hi,
I am trying to create a tooltip for table visual but I am not getting how to write the measure for that. When the user could hover over any date(28 sep 2015 ) on a Date column, for example, under 11111 Account. The tooltip could show the subtotal (Sum of corresponding Accounted Amount column) for 11111 Account for the date (28 sep 2015). And so on. Similarly, hovering over the Type entries (e.g. Payment) would show the sum of all Payment type for Account 11111. Please tell me how to do that.
I am attaching the .pbix file please help.
https://drive.google.com/open?id=1bkWbZxO3gMdswWDEv0bDUcfFpWYrAqqB
Hi kiranbchitari
You can try adding the following measure to be used in tooltipToolTip1 =CALCULATE(SUM(Sheet1[Accounted Amount]),ALLEXCEPT(Sheet1,Sheet1[Date],Sheet1[Account]))
I have attached the pbix file in which I have created two measures to show the total with "All types" on a date and the total with the hovered line "type" and "date"
Here is the pbix, you can try
https://www.dropbox.com/s/jdv7tro4a4txc39/How%20to%20create%20tooltip%20for%20table%20visual.pbix?dl=0
Please accept as a solution if this helps.
Regards
Affan
6 Replies
Hi kiranbchitari
You can try adding the following measure to be used in tooltipToolTip1 =CALCULATE(SUM(Sheet1[Accounted Amount]),ALLEXCEPT(Sheet1,Sheet1[Date],Sheet1[Account]))
I have attached the pbix file in which I have created two measures to show the total with "All types" on a date and the total with the hovered line "type" and "date"
Here is the pbix, you can try
https://www.dropbox.com/s/jdv7tro4a4txc39/How%20to%20create%20tooltip%20for%20table%20visual.pbix?dl=0
Please accept as a solution if this helps.
Regards
Affanaffan Thanks for your help.:smileywink:
Select your table visual. Go to the paint roller icon (format). Scroll down and turn on Tool Tip.
