EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials PowerBI Tutorial Power BI Tooltips
Secondary Sidebar
PowerBI Tutorial
  • Advanced
    • Power BI Tutorial
    • KPI in Power BI
    • Power BI Calendar
    • Power BI Dashboard Samples
    • Power BI DAX
    • Power BI Filter
    • Power BI Icon
    • Slicers in Power BI
    • Power BI IF Statement
    • Power BI Template
    • Power BI Maps
    • Measures in Power BI
    • Power BI Report
    • Power BI SUMX
    • Power BI Charts
    • Power BI Pie Chart
    • Power BI Bullet Chart
    • Power BI Gantt Chart
    • Power BI Bubble Chart
    • Power BI Waterfall Chart
    • Power BI Drillthrough
    • Power BI Themes
    • Power BI Tooltips
    • Power BI Heat Map
    • Creating Reports in Power BI
    • Power BI Connections
  • Basic
    • What is Microsoft Power BI
    • Is Power BI Free?
    • Power BI Visuals
    • Power BI Parameters
    • Power BI Alternatives
  • Interview Questions
    • Power Bi Interview Questions

Related Courses

Power BI Certification Course

Business Intelligence Certification Course

Data Visualization Certification Course

Power BI Tooltips

By Priya PedamkarPriya Pedamkar

Power BI Tooltips

Introduction to Tooltips in Power BI

In this article, we will see an outline on Power BI Tooltips. Creating a chart in Power BI is an easy thing. Tooltips in many charts help us to get additional data labels apart from the values which are already there visual’s fields. But adding tooltips in that chart makes the view more detailed. Adding tooltips in any chart, makes that charts look more valuable without increasing additional columns, bars or lines on the charts. After adding tooltips, we just need to hover the cursor on the chart, we will be able to see the additional added field values there in the box.

How to Use Power BI Tooltips?

We do not have to go anywhere to find Tooltips unless we want to add a new Chart type into the visualization section. Once we create any chart we will be able to find the Tooltips there in the Fields section of Visualization.

To see tooltips, first, we need to create a chart. Here we have select Stacked Column Chart from the list. Without selecting the data fields we will be able to see tooltips under Fields of the selected chart.

Power BI Tooltips Example 1

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

As we can see the description of Tooltips which says “Add data fields here”. We can add one or more than one data field here. You can also download the excel workbook from the below link which is used for this example.

You can download this Power BI Tooltips Excel Template here – Power BI Tooltips Excel Template

Example #1

  • We will use the sales data of electronics products and we will convert this data into a tabular form so that we could project some charts out it.

Power BI Tooltips Example

  • Click on Get Data which is there in the Home menu ribbon in Power BI. Select the source file and upload it. Here our data is in Excel.

 Example 1-1 (Menu Ribbon)

  • Then browse the file location and open it. From the Navigator window, select the sheet which we want to Load. Here the summary of sales data is in Sheet2.

Power BI Tooltips Example 2

  • We will see our data is now uploaded into the Power BI system.

 Example 3(Fields)

  • Once the data is upload, now we select the chart which you want to create. Here we are selecting a basic Stacked Column Chart which is most commonly used.

Power BI Tooltips Example 4

  • Now drag the fields which we want to see. Here we are using City name in Axis and Total Sale in Value.

Power BI Tooltips Example 5

  • We will get our basic Stacked Column Chart as shown below.

Example 6 (Stacked Column Chart)

We can do the basic formatting such as border, data labels, column colors, etc. as needed.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,527 ratings)
  • Now if we, however, move the cursor on any of the columns in the created chart we will be able to see only City Name and Total Sale which we have used while creating this chart.

Power BI Tooltips Example 7

What if we want to see the other values as well apart from these selected 2 values? This is only possible using Tooltips function which is only available in Power BI. This type of function is not available in Excel, even though it has most of the features which we do for creating charts.

  • Let’s drag a value from the Fields section say Quantity into tooltips.

Example 8 (Quantity)

  • Now if we, however, move the cursor on the same column with City name Cochin, we will now be able to see Quantity as well for which value is reflecting as 6098.

Power BI Tooltips Example 9

By this, we can summarize, for City Cochin total sale was Rs. 4301800/- from the quantities 6098.

  • Let’s try to add another field into tooltips. Now we are adding Customer Count.

Power BI Tooltips Example 10

Now again, if we hover the cursor on Cochin, we will see Customer count is also reflecting there with the count of customer 167.

Power BI Tooltips Example 9

Again if we summarize this as for Cochin city, total sale was Rs. 4301800/- with quantities 6098 from 167 Customers. This is how tooltips in Power BI works.

  • We can even further customize the view of data reflecting on tooltips. For this, click on the down arrow which is on each of the fields under tooltips.

Power BI Tooltips Example 12

  • Now select any of the mathematical functions from the list as shown below, to get further changes in the view.

Example 13 (Mathematical Function)

Pros of Power BI Tooltips

The pros are:

  • Without any further addition to the created charts, Tooltips gives us more details.
  • There are no limits of adding fields in tooltips.
  • Tooltips are used to show more informative charts and data.

Note: I have done so much of formatting to these charts, you can download the Power BI Tooltip file from below link and apply each formatting technique as applied.

You can download this Power BI Tooltips Template here – Power BI Tooltips Template

Things to Remember

Things to remember when using Powerbi tools:

  • We can customize the tooltips by choosing the type of mathematical operation such as Sum, Average, Percentage, Variance or Median to modify the views for tooltips without changing or modifying the data.
  • Tooltips can only be accessed through a Report view in Power BI. This is the only place where can change anything in the chart without doing further changes to uploaded data.
  • It is important to know what we want to see or show using tooltips customization. Although using the default properties of tooltips will also give the output but while selecting the custom operations, first determine the output we want to see.
  • We do the changes in the uploaded data in the Data view tab or using the Query editor. But if the size of data is not big then if it is better to change the data in Excel instead of in the Power BI query.

Recommended Articles

This is a guide to Power BI Tooltips. Here we discuss how to use Power BI Tooltips to show additional data labels in the chart along with practical examples and downloadable power bi template. You may also look at the following articles to learn more –

  1. Use of Power BI IF Statement
  2. Power BI Heat Map (Examples)
  3. Custom Visuals in Power BI
  4. Types of Power BI Connections
  5. Power BI Themes | How to Apply?
Popular Course in this category
Microsoft Power BI Training (6 Courses, 4 Projects)
  6 Online Courses |  4 Hands-on Projects |  45+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Power BI Tooltips Excel Template

EDUCBA

Download Power BI Tooltips Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more