Forum Discussion

kiranbchitari's avatar
kiranbchitari
Frequent Visitor
7 years ago
Solved

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, unde...
Need Help
Show and Tell
Tutorial Requests
affan's avatar
affan
Solution Sage
7 years ago

Hi kiranbchitari

You can try adding the following measure to be used in tooltip

ToolTip1 =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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

does this work when pinning the report into a dashboard? it seems it only works when interacting with the report item but not dashboard.