• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Custom Tooltips in Power BI

You are here: Home / Power BI / Custom Tooltips in Power BI
custom tooltips in power bi
June 2, 2022 by Philip Treacy

When you hover your mouse over an element in a visual, like a column in a clustered column chart, a tooltip like this appears.

default tooltip

The mouse is over the first orange column so the tooltip is showing the country, year, and sale total for that column.

The country could be removed as you can tell this from the X axis. Also, I feel the year isn't needed in the tooltip. You can see the years in the legend and each cluster of columns is always 2011, 2012, 2013, 2014 from left to right, which I find easy to remember.

This Works In Power BI Service Too

I'm using Power BI Desktop in this example but the process is almost identical in Power BI Service.

Watch the Video

Subscribe YouTube


Download Example Power BI File

Enter your email address below to download the sample PBIX file.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download PBIX file


Creating a Custom Tooltip

What I need is a custom tooltip that just shows me the Total Sales for the column I've got my mouse over.

To start this process, create a new page either by clicking the + in the yellow square at the bottom of the page, or from the Ribbon -> Insert -> New page

In Format Page -> Page Information, set the page name and click on Allow use as tooltip.

set page name

in Canvas Settings - choose type and set page size if using Custom. You can choose a number of different pre-defined types (page sizes) but you can use any size if you choose Custom.

I'll set the height of my custom page to 120 pixels, width is 320 pixels.

canvas settings

 

Then set the Page View to Actual Size

set page to actual size

 

Add a card visual and add Sale Total to it, renaming that to Total Revenue.

add card and data field to tooltip

By dragging Country to the Tooltip area, whenever you hover over Country in a visual, this tooltip will appear.

add country to tooltip

Back in my clustered column visual, when I now hover over a column, I see the new tooltip.

Your browser does not support the video tag.

 

 

Breakdown of Sales by Each Country

I've got another visual showing Revenue by Year by Region. The default tooltip shows Region, Year and Revenue.

I think I can do without the Region, and probably the Year. Revenue is needed but what would make this even better is if the tooltip showed a breakdown of the column so that I could see the contribution each country makes to the column's total.

default tooltip revenue by region

To create the new tooltip, the first few steps are the same as before. Add a new page, in Page Information name the page, and enable Allow use as tooltip.

Under Canvas settings I'm going with the Tooltip type. The height and width of this is set already.

tooltip settings

Then from the Ribbon, set Page View to Actual Size.

What I'm actually trying to do here is use my first visual (Revenue by Country by Year) as the tooltip for the Revenue by Region by Year visual. So to save a bit of time, I can copy and paste the Revenue by Country by Year clustered column visual from the main page into the tooltip page

I resize the visual and remove unwanted parts. I want it to only show the minimum, useful information. No need for things like the legend, axis titles and such. I end up with this.

tooltip with just chart

I want to see this tooltip just for a specific visual, not every time I hover over a region. To set this, go back to the main page, and with the relevant visual selected, go to Format visual -> General -> Tooltips

set tooltip for visual

Make sure Tooltips is set to On and in Options set Type to Report Page and choose the name of the Page

This is what the tooltip looks like when it pops up in a visual

tooltip chart on visual

That's good but I can make the tooltip more useful by adding a figure for Sale Total to the bottom of the tooltip.

Back in the tooltip page, add a card (exactly as I did in the first example) and add Sale Total to this, renaming it Total Revenue

chart and card in tooltip

The tooltip now looks like this on the visual

tooltip showing chart and card

Perhaps one more thing might help, adding the year to the top right of the tooltip. Up to you if you feel like this needs to be included.

On the tooltip page, add another card, add Year to the card with the aggregation MIN, and shrink the card down really small and position it in the top right corner of the tooltip page.

year added to tooltip

This is what the final tooltip looks like.

Your browser does not support the video tag.

I'm really happy with that. It provides far more useful information than the default tooltip

Perhaps one more useful addition to the tooltip would be to add data labels to each column. I'll leave that to you to figure out how to do.

Hint : select the clustered column visual on the tooltip page then go to Format Visual -> Data Labels

tooltip with data labels on columns

custom tooltips in power bi

More Power BI Posts

conditional formatting tables and matrices in power bi

Conditional Formatting in Power BI Tables and Matrices

How to apply conditional formatting to tables and matrices in Power BI. Use color, icons, data bars and URL's.
dax editor keyboard shortcuts

DAX Editor Keyboard Shortcuts

Keyboard shortcuts for the DAX editor in Power BI. Learning DAX is hard enough. Make your life easier by using these keyboard shortcuts.
fixing incorrect totals in dax

Fixing Incorrect Totals in DAX

If you're getting incorrect totals in your DAX measures, this post explains how to fix them. VIDEO and Sample file to download.
highlighting data in power bi visuals

Highlighting Data in Power BI Visuals

Learn several techniques to highlight or label important data points in your Power BI visuals. Sample file and code to download.
Power BI Organizational Data Types

Power BI Organizational Data Types in Excel

Power BI Organizational Data Types in Excel revolutionize the way we store and access our data with one central location and small files.
shape maps in power bi

Shape Maps in Power BI

Shape maps in Power BI can be used to show the distribution of a variable across geographic regions. Learn a trick to plot discrete data too.
static data tables

Static Tables in Power Query, Power Pivot and Power BI

Use static tables to store data in Power Query, Power Pivot and Power BI without needing to load data from an external source

Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI

Convert times and durations from decimal numbers to easily understood formats like hh:mm:ss. Sample code and file to download.
Power BI Dashboards

How to Build Power BI Dashboards

This video tutorial takes you step by step through building Power BI dashboards and reports, including publishing and sharing.


Category: Power BI
Previous Post:Embedding Excel Dashboards in a Web Page
Next Post:5 Excel Online Features Better than Desktopexcel online

Reader Interactions

Comments

  1. Gina Lopez

    June 2, 2022 at 10:22 pm

    I have a team that conducts inventory of equipment and other items for our college system and separates reports by departments, annual losses and total costs. I’d like to report other useful data to my bosses, but not sure how to develop trends or quick reports that can tell them something about the losses or totals. Any ideas?

    Reply
    • Mynda Treacy

      June 3, 2022 at 3:39 pm

      Hi Gina,

      Trends usually require a timeline (days, weeks, months, years etc.), or some other form of relationship between the data points. What you can do will depend on the data you have and what the drivers are of the business. It’s difficult to give you specific ideas without this understanding, however you might find our Power BI course or Excel Dashboards course helpful for ideas.

      Mynda

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.