Ravindra BagaleCourses & study guides मराठी Track your progress

18. Tooltips

18.5 Tooltip Examples on Our Data

Start with a problem

Rani asks for three useful tooltips on the delivery page: one on the city chart, one on the store matrix, one on the trend line.

Explain simply

Choose tooltip content that answers the next question a reader will ask after seeing the value.

Show the data

Visual Next question Tooltip content
City bar How fast is it? Avg mins, % under 10
Store matrix Which platform? Blinkit vs Amazon Now sales
Month line Versus target? Target and % achieved

About this data: This table uses columns: Visual, Next question, Tooltip content. This table uses columns: Hover, Tooltip. This table uses columns: Main visual, Tooltip idea, Type. This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv, monthly_targets_fy2026_27.csv (source: src/practice/).

Demonstrate

  1. City bar: add Avg Delivery Mins and % Under 10 to Tooltips.
  2. Store matrix: use a report page tooltip with a small Platform bar chart.
  3. Month line: add Target and Achievement % = DIVIDE([Total Sales], [Target]).
  4. Hover each visual and compare with the table below.

Show the result

Your result should look like this (fictional sample):

Hover Tooltip
Kothrud (matrix) Blinkit ₹650, Amazon Now ₹0
College Road (matrix) Blinkit ₹150, Amazon Now ₹350
May-2026 (line) Sales ₹1,200, Target ₹1,100, 109.1%

Explain what happened

Each tooltip uses the hovered item's filter: store or month.

Explore further

  • Avoid repeating the visual's own value only.

Detailed reference for this lesson:

Main visual Tooltip idea Type
Orders by City (bar) AOV, Avg Delivery Time, Cancellation Rate Extra fields
Dark store bubble map Store Name, Area, Orders by hour (mini chart), Top 3 products Report page
Daily orders line chart Festival name for the date ('Date'[Festival]), Orders LY Extra fields
Category treemap Top 5 products in the category (mini bar chart) Report page
Platform donut Blinkit vs Amazon Now AOV and % Under 10 Mins Extra fields

Practice task

Create a report page tooltip TT Store (Tooltip canvas) with three cards and a mini line chart, set Store Name as its tooltip field, and use it on the dark store map and on a bar chart of Orders by Store Name.

Ravindra Bagale's Tip

A common tooltip mistake is showing the same number that is already on the bar. A tooltip should add context, like last month's value, the target or the top product. Ask yourself "what would the manager ask next?" and show that. Don't make this mistake!

Fix common mistakes

Wrong result Reason Correction
Target blank on the line Targets not related to Month Relate targets by Month
Kothrud Amazon Now shows blank No rows Use + 0 in a measure only if zero is meaningful
Tooltip too big Too many visuals on tooltip page Keep 2–4 elements

Practise independently

Practice task

Hover April on the line. What does the tooltip show?

Hints
  • Target 1,000.
Solution

Sales ₹900, Target ₹1,000, Achievement 90.0%.

Think like a professional

Good tooltips reduce the number of pages. They show you understand the reader's next question.

Thodkyaat sangaycha tar (quick recap)

A tooltip should answer the next question, not repeat the same number. For a report page tooltip, the field must be in the main visual. Now let us move on to bookmarks and navigation.

Ravi Sir's Cards for this lesson

मराठी cards