cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kiranbchitari
Frequent Visitor

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.fig 1.PNG

 

 

I am attaching the .pbix file please help.

https://drive.google.com/open?id=1bkWbZxO3gMdswWDEv0bDUcfFpWYrAqqB

1 ACCEPTED SOLUTION
affan
Solution Sage
Solution Sage

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"

Tooltip.png



Here is the pbix, you can try
https://www.dropbox.com/s/jdv7tro4a4txc39/How%20to%20create%20tooltip%20for%20table%20visual.pbix?dl...

Please accept as a solution if this helps.

Regards
Affan

View solution in original post

5 REPLIES 5
affan
Solution Sage
Solution Sage

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"

Tooltip.png



Here is the pbix, you can try
https://www.dropbox.com/s/jdv7tro4a4txc39/How%20to%20create%20tooltip%20for%20table%20visual.pbix?dl...

Please accept as a solution if this helps.

Regards
Affan

View solution in original post

Anonymous
Not applicable

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

@affan Thanks for your help.Smiley Wink

on hover the total tool tip shows wrong data (its showing first row data insted of total)

Greg_Deckler
Super User IV
Super User IV

Select your table visual. Go to the paint roller icon (format). Scroll down and turn on Tool Tip.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors