EVERYTHING you wanted to know about Power BI tooltips

Power BI tooltips can add a lot of context to a visual. Patrick shows you everything you need to know about tooltips in Power BI!
Prathy's (@pkamasani) Blog about Visual Header Tooltips: prathy.com/2019/07/power-bi-v...
Download Sample: guyinacu.be/tooltipsample
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Tooltips #GuyInACube

[@amitshukla189]

How easily you explain anything that is your charm Patrick. You can explain any complex concept in a simple way.

[@jhewitthunt]

Love these tips Patrick. I could watch your videos all day. You explain stuff so well. Thanks!

[@graemegourlay2850]

Great tutorial. I hadn't thought of using report and visual header tooltips in my dashboards; this has triggered some new design ideas for me that I'll be including in my next project.

[@dbailoor42]

I loved the tips (or tool-tips). Definitely something I will be incorporating in some of my dashboard designs. You're amazing! I have learnt a lot about Power BI from your videos.

[@mattsnow2376]

Patrick this was really helpful; I had never realized that placing measures in the tooltips area actually impacts the query efficiency. Also the report header tooltip idea was great as well

[@stefaanlouette]

You guys really make THE best PowerBi video's on the net. Keep going !!

[@mattallen8906]

I just want to say how awesome all your videos are. They are easy to understand and very informative. They have helped me become better at using Power Bi!

[@dhyrumc1987]

Ran across the Report Tool Tip capability in the Power Bi Data Analyst Cert training I was doing and thought...what?? You can do that?? Found this video and now I am so excited to use it in my reports. This is a great way to declutter the report page as well so that data can only be visible when needed. Love it, thanks for sharing!

[@marvinmyburgh4352]

Love this video of tooltips.....just had a report with tooltips today adding both visual and report tooltips......great video. Thanks for your how to and guide👍🏼👍🏼

[@floorenciaa22]

Great video!! This is a very good introduction to be able to understand what Tooltips are and follow the rest of your Tooltips videos. Before this one I didn't understood what was the tooltips box for. Thanks!

[@alfredsfutterkiste7534]

Love the idea of using visual header tooltips to provide extra information about what is being presented... def gonna use that

[@yashasvityagi]

Hey Patrick, Watching your videos from last few months and they are really helpful. Thank you and keep up the good work.

[@jjones0304]

Great video Patrick! I thought I knew everything about tooltips but you provided some creative ways to use them. Love the maps legend idea.

[@JoseSalazar-jm8os]

Those tool tips are awesome! I am learning how to create powerful visualizations with PBI, and I am finding this channel very enlightening.

[@niranjansaikrishnac4394]

You guys are always awesome. Thank you so much for the tooltip visuals explanation.

[@jermainecameron6209]

Love this video and I especially love the Header Tooltips. Brilliant stuff as always!!

[@carn9977]

Love these videos. How to create and deliver more context per visual. Huge potential.

[@bladerunnerisback]

Great video as always. Thank you! One more useful thing about tooltips is that any field you add to a tooltip can be used to sort the data on the visual.

[@mahshidfathi9284]

Thank you so much for sharing this tutorial about tooltips. Your videos are awesome!

[@patsharpe2487]

Just used the Visual Header tooltip.. great idea! Thank you

[@AyilliathArun]

Thank much for video, it was really a life saver. You explained the concepts very well.

[@rossrobinson4834]

Another great video for another innovative solution. Thank you Patrick.

[@OrionDauphin]

There is so much value here. Instant subscribe!

[@thearshu27]

Awesome video as always..Keeping it simple!!! can you kindly put up some video or share something on embedding dashboards on a public link and how to use filters there. This is basically for my clients who do not have Power BI subscriptions.

[@SachinGupta-bk8mt]

Thanks Patrick, that Report tool tip is amazing 👍

[@katerinazorko3756]

Thanks for a great video! Really helped me to add the tooltips I needed. :)

[@daart4033]

Thank you for this video, I love it. Can you do it again with more tables, maybe 3 o 4, and add a data table as well. I would like to understand how all that gets connected. Thanks.

[@mikepeezy]

This video was great!!! Never really understood how to use the various tooltips. My reports are going to really stand out with these in use. Thanks!

[@GuyInACube]

Happy it helped

[@JDAeroVR]

Nicely done! Thanks for the clarifications!

[@akumaran]

Lovely thanks a lot guys you are making ppl happier.

[@danielfox3399]

I love your videos and your energy! Thanks!

[@meetdenis82]

Great video again! Question: Why can't the sync slicer method shown for visual header tooltip, be also used for report tooltip?

[@anthonypcheng3167]

Cool. Guy in a Cube has been my first daily morning news update so far. :-)

[@ezekiel0606]

amazing content! thanks, Patrick

[@cjslcjr]

Thanks, this is a great way to use tool tips!

[@Anthony_Lecoq]

Merci Patrick ;) Super job

[@biglachers]

Thanks for the great video. Is there anyway to make a tooltip pop up and stay up when you click, rather than pop up when you hover and disappear when you stop hovering?

[@marksearle2012]

This is amazing, so helpful, thank you!

[@rainyman248]

Thanks for your awesome videos. Patrick, just wondering if it's possible to add report page tooltips to slicers??

[@HugoM-USA]

Hi Patrick, Great material. I have the challenge in a line chart to get a tooltip that has the cross line as you showed in your example. Marker, Name, Qty . Any hints? Thank you!

[@shanakaperera1207]

very helpful, can you explain why all my data in the tooltip box not shows (can't scroll). some text hides. how to adjust the tooltip box size or enable scroll? Thank you.

[@juanignacioXI]

Awesome Patrick, can u share the dax for the Visual Header Tooltip Top 10 please?

[@mxvideos161]

Thanks for the video, really easy to follow. It had almost everything I needed to know :) Do you have any that go into a little more detail on the tooltip field options. I am try to have a map and when you hover over a region a specific tooltip is shown (not all the same)

[@Metalblowing]

Using but this video gave some new ideas. Cheers mate.

[@massimocolaceci]

I really enjoyed this content! Thanks Patrick!

[@GuyInACube]

Most welcome! Thanks for watching and supporting the channel! 👊

[@vickyliu2431]

useful tutorial, thank you so much to share with us

[@amysato5892]

great video. Thanks for explaining. How do you get the pages options in your tooltip selection? Mine has an "auto" option only despite having multiple pages.

[@PrideEnchantaVagale]

Thanks for the video. I have a question. I have a table with values and added report page tooltip. On the value the tooltip show up with information. But if table cell value is blank, the tooltip pops up but it's blank. How to avoid showing of blank tooltip popup in blank cells?

[@venke75utube]

Patrick this tips are awesome.

[@mirrrvelll5164]

Great video! Useful as usually!

[@ianstuart2505]

I love custom tooltips and I like what you did with the sync slicers Patrick. How accessible are tooltips from mobile devices and keyboard shortcuts? I have heard that is a limitation?

[@joaquinmaverick82]

Great video, as always!

[@alinescribner5109]

hey Patrick, nice video! How to add additional tooltip on the table kind of visualization?

[@jessicajolly7828]

Brilliant! Love this.

[@theA12d1]

you are the legend bro ! thanks !

[@honestreviewerwand3800]

Very well explained (with some charm too!). I have a Tooltip related question which I'm hoping you can answer please. Short version: My tooltip values don't update on interactions. Long version: I have a stacked bar chart where the values displays % and the tooltip contains a number measure. When I click on a segment of the bar chart the percentage of another bar chart will update (great, I want that) however the number measure within the tooltip is not updating with it. I feel like it should just happen and I'm missing something painfully obvious - please help ! Apologies if you've already covered this in a previous video :)

[@stephencross4978]

Great Video thanks! How do I do the same thing, with data from 2 tables? I have a customer order table, and I have a report listing all the materials that are owing to customers. Then I want a tooltip that checks the stock table, finds the stock for the material number that I'm hovering over and shows this stock figure in the tooltip. When I do this now, I'm getting a list of other materials not related to my selected material in any way

[@AndrewDixonMusic]

Anyone know if it's possible to have the hover over tool tip stay on screen when you put your mouse over it? I have a graph display on hover over and am hoping to have it show the individual data values on the chart when I hover over it (like what happens on the separate tab it was created on). Currently as soon as I move my mouse towards the hover over it disappears!

[@nileshpnilesh]

Thank you Patrick! I have a scenario wherein I have a Table and I want to show Tooltip for each column header. Is there a way to achieve it.

[@malla1990]

Great video, thank you! But how did you create the tooltip message?

[@ppurwarpurwar812]

Hello Patrick , can we change the Lable of dynamically i want to show the percentage like X% of y amount is remaining to pay or over paid

[@balasubramanian5232]

Hi Patrick.. Awesome video. Just a quick question. How the report level tool tip is dynamic? Do we need to adjust any specific settings? I mean how the page for report level tool tip is set so that it displays the tip corresponding to the element it is hovered upon. Thanks in advance

[@neilross1662]

Another Great Video Patrick. How did you build the Tool Tip Map Legend? I have a map in a report and would like to do the same just a simple narrative and the colour bar

[@raulcadenas7999]

Thanks a lot Patrick, great video and very useful 👍🏻

[@GuyInACube]

We appreciate that Raul! 👊

[@AnandKumar-xf3ro]

Thanks for the video..I have one question ..Can you or anyone tell me how to add two measures in x axis and y axis in bubble chart ...

[@jamesmajcen5695]

Oh the report tooltip is definitely going into my bag of tricks.

[@danielstahl1103]

Timely! Thank😃 you!

[@kahhengyeong7947]

Thanks for the trick which I learnt from you guys and have used but just to share one "down side" that I've experienced with this tooltip is that if you left the Power BI on without refreshing the browser for a long time, the info on the main visual may not tally once information in the database changes. Example is that the main visual shows the total number of any product type reserved and the tooltip shows the breakdown of customers who reserves the product being hovered on. There were times I realised the number on the main visual is different and after an F5 browser refresh, the number tallies. That is because the main visual does not automatically refresh if user just leave the browser on while the tooltip is always dynamic and gets the latest info from the refreshed database. Hope this makes sense and helps those who uses this trick but found discrepancies in their numbers.

[@just_pbi]

@Patrick, I came across this awesome video of yours and wanted to try out Visual Headers in my current Power Desktop Version (Version: 2.117.984.0 64-bit (May 2023)) and I noticed that the Visual Headers are not available. Did Microsoft remove them?

[@picssuxxx]

Amazing! You Guys in a Cube are THE guys in a cooooolbe! lol TKS =*

[@baluragoonathan3666]

Great Video on Tooltips Patrick!

[@GuyInACube]

Appreciate that Balu! Thanks for watching 👊

[@destroyer3706]

For different visuals in a report, do we need to create separate tooltip pages? one for each tooltip, or can we have multiple tooltip in only one page for the different visuals.?

[@alexsin4821]

Its great. Finally someone explain what the hell this tooltip is and how to use it. Thanks.

[@GuyInACube]

Glad it was helpful for you! 👊

[@op03p43]

Hello, do you know how to jump to last row to check whether it has "null" in the cell or not because I have 50,000 rows in my file and it takes so much time going to last row by clicking my mouse on the arrow...

[@AW-rr3fl]

Can a custom tooltip be added on a button? For example as info? I have a panel I show and hide but wondered if there was standard bi way of achieving this?

[@garycougar5519]

Patrick, just watched this video and it is amazing! I have a small question that I have not found the answer to. Is it possible to remove some field from the tooltip. For example, the "Month" field in your first example, it is a value field, so by default, it is part of tooltip items. Can it, as well as the data field, be removed from the tooltip, and only show those I add to the tooltips? Thanks

[@NerdineNadine]

Is there any chance to export the information poping up from the tooltip? (e.g.a visual showing amount of customers by product group and sales and users want to export a list of these customer in a special sales group)

[@sylviedaigle7304]

In this viéo you mentionne that there is the visual report tooltip . Where in that option in RS version? I want to pass différent value ...

[@RVAraghav]

Hi Patrick. Is it possible to have a column-level tooltip in tables?

[@annjake4260]

Hi Patrick..Can we see tool tip for explaining the calculations of the columns in a table. The titles and their meanings are stored in another table and this should get pulled over when we hover over the column..

[@AlimMemon]

I have a table visualization and associated with that a report tooltip. Currently, this tooltip is showing up on all the columns of the table visualization but it only needs to show up on the first few. Using matrix visualization is not an option. Is there a way to do this somehow?

[@mihir_thakkar4305]

Thanks for making the tooltips application so easy to understand. I have a small Question, if we have a drill down enabled on a visual, then can we have different tooltips for different levels. like for example, if there's a barchart for product category, which drills down to product subcategory, then i want to make a tooltip such that if i'm on category's view, I get information about the category. If i drill down to sub category's view the i should get information about the subcategory. I dont mind making seperate tooltips for the category view and the subcategory views, I just want to know if i can apply seperate tooltips for various drill down levels and if it's possible then how to apply??

[@kennethstephani692]

Great Video!

[@raquelrivera4306]

Hi Patrick, how do I make my Tooltip filter simultaneously with my visual? For example, if I am on March, I want my tooltip to show March data, if I'm on April then April data. I made my tooltip but it is not responding to my filters. Thanks a bunch!

[@julianocorma]

Very cool. Thank you

[@sandeepreddy7687]

Thanks! for this tip

[@fcnc3024]

How do you stop the First or Last value for Tool Tip?

[@RahulRautela5797]

thank you Patrick 🙂👍

[@sandhyasubramanyam3131]

Hi ..I have a requirement of dynamical filter to choose absolute value or % to be displayed. Can you let me know if you have solution for same.For example I have a table with Location and respective employee count. In dynamic files user should see option to select value or % when they select % automatically the table shold show % of grand total instead of count of employees.

[@pankajsonawane3958]

Hey Patrick i have one card with some values for which i have set units to million but using tooltip i want to see the whole value how can i do that?

[@manojpraveen5976]

Hey, i am not receiving any sample data to work on. Could you please share me a link to download them?

[@Drewschen]

We have a scenario like this but slightly different. Our customer wants the ? to be visible all the time, like an info icon. On images there are only visual header tooltips and actions but no tooltip options. Is there any way of getting this to work? I tried bookmarks but that doesn't have the desired effect.

[@Alpacastan21m]

How do I display units for time in a tool tip ? Example :- "52 seconds"

[@benjaminp6815]

Love this guy

[@tracycox7286]

Is there anyway to remove values from a tooltip? An example is a map using latitude and longitude. There's information I'd like to include on a tooltip but the coordinates are not relevant to the user and I'd rather not clutter the tooltip with them. Thanks

[@soldevhelp]

great video and great delivery style - i like it :)

[@GuyInACube]

Appreciate that Michael! Thanks for watching 👊

[@marksearle2012]

I have a question - is it possible to make the tooltips stay on the screen? And subsequently interact with the tooltip? For example, my tooltip might display a list of cases relevant to the part of the graph the user has hovered over, but the list may be long and have a scroll bar. Can you make the tooltip stay in place and use the scroll bar?

[@riazuddin7493]

I have created a report and in this report there are two visuals i.e. Exits by Grade and Exits and Turnover by Department. The former visual displays the grade wise number of leavers whereas the latter displays the data related to number of leavers and turnover percentage. If I select a articular grade in Exits by Grade then the visuals of Exits and Turnover by Department displays data correctly related to 1. Overall Turnover percentage of departments. 2. Highlighted Turnover percentage of the particular grade which was selected from the previous visuals for a particular department. 3. The total number of leavers of the department. But I also want to see 4. The total number of leavers in selected grade for the particular department. How can I achieve this?

[@pardeepjanjua78]

Are you able to add a tooltip to a filtered table, filtered table was created using selectcolumns?

[@ravitejau7179]

Hey @patrick I need to transfer power bi service comments to sql database is it possible can you explain?