18.2 Adding Fields to the Tooltip
Start with a problem
Shraddha wants the city tooltip to also show orders and average delivery minutes, without adding more bars.
Explain simply
Drag extra fields or measures into the visual's Tooltips well. They appear only in the tooltip, evaluated for the hovered point.
Show the data
| City | Orders | Total Sales (₹) | Avg delivery mins (delivered) | Under 10 min |
|---|---|---|---|---|
| Pune | 3 | 850 | 12.0 | 1 of 3 |
| Nashik | 3 | 800 | 11.3 | 1 of 3 |
| Kolhapur | 2 | 450 | 7.0 | 1 of 1 |
| Total | 8 | 2,100 | 11.0 | 3 of 7 |
About this data: This table uses columns: City, Orders, Total Sales (₹), Avg delivery mins (delivered), Under 10 min. This table uses columns: Hover, Tooltip. 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 (source: src/practice/).
Demonstrate
- Select the City bar chart.
- Drag
Total OrdersandAvg Delivery Minsinto Build › Tooltips. - Format both measures (whole number, 1 decimal).
- Hover Nashik.
Show the result
Your result should look like this (fictional sample):
| Hover | Tooltip |
|---|---|
| Nashik | Total Sales 800 · Total Orders 3 · Avg Delivery Mins 11.3 |
| Kolhapur | Total Sales 450 · Total Orders 2 · Avg Delivery Mins 7.0 |
Explain what happened
Tooltip fields use the bar's filter context. Avg Delivery Mins ignores the blank time of the cancelled order, so Kolhapur shows 7.0.
Explore further
- Rename fields in the visual (double-click in the well) to give friendly tooltip labels.
Detailed reference for this lesson:
Steps in Power BI
- Select the bar chart "Orders by City".
- In Build visual, drag
[AOV],[Avg Delivery Time (mins)]and[Cancellation Rate]into the Tooltips well. - Hover over a bar. The tooltip now shows four values.
- To change how a tooltip field is summarised, use the drop-down on the field in the Tooltips well (e.g. Average, Count (Distinct)) or, better, use explicit measures.
- Rename a field for this visual only: double-click it in the well (e.g. "Avg mins").
Tip
Mhanje asa: tooltips are a great place for secondary KPIs. The chart stays clean, and the detail is one hover away.
Ravindra Bagale's Tip
A common mistake is adding too many fields to the Tooltips well, so the tooltip becomes a wall of numbers. Add two or three measures that answer the next obvious question, for example Orders and Avg Delivery Time on a sales-by-city chart. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे Tooltips well मध्ये खूप fields जोडणं, त्यामुळे tooltip म्हणजे numbers ची भिंत होते. पुढचा साहजिक प्रश्न सोडवणारे दोन-तीन measures जोडा, उदाहरणार्थ sales-by-city chart वर Orders आणि Avg Delivery Time. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
एक common गलती है Tooltips well में बहुत सारे fields जोड़ना, जिससे tooltip numbers की दीवार बन जाता है. अगले स्वाभाविक सवाल का जवाब देने वाले दो-तीन measures जोड़ो, जैसे sales-by-city chart पर Orders और Avg Delivery Time. एक बार फिर करके देखो, फिर आगे बढ़ो.
Fix common mistakes
| Wrong result | Reason | Correction |
|---|---|---|
| Avg shows 3.5 for Kolhapur | Blank delivery replaced by 0 in Power Query | Keep blanks, or average delivered rows only |
| Tooltip shows Count of Order ID | Column dragged instead of measure | Use Total Orders measure |
| Labels too technical | Field names | Rename for this visual |
Practise independently
Practice task
Add % Under 10 to the tooltip. What does Pune show?
Hints
- Pune delivered: 8, 12, 16 minutes.
Solution
33.3% (1 of 3).
Think like a professional
Tooltip fields are cheap to add and great for why questions. Keep them to 3–5 values.
Revision card