How a Business Central Power BI Tooltip Works
A tooltip is configured within Power BI and associated with a visual or report page. When the user points to a relevant data element, Power BI passes the selected filter context to the tooltip page. The tooltip then displays measures and visuals calculated for that specific selection.
For example, a revenue chart may show monthly sales as the primary visual. Hovering over April could display a tooltip containing customer count, gross margin, invoice volume, budget variance, and year-to-date revenue. The information changes according to the selected month, company, customer, or other dimensions available in the Business Central data model.
- Source data: Business Central tables and related reporting datasets provide the underlying financial information.
- Measures: Power BI calculations determine the values displayed in the tooltip.
- Filter context: The hovered data point controls which records and calculations appear.
- Tooltip page: A dedicated report page can contain supporting charts, cards, and financial indicators.
Key Financial Information to Include
A well-designed tooltip should provide information that helps explain the selected value rather than simply repeating the main visual. For accounts receivable, a tooltip might show invoice count, overdue amount, customer balance, and collection status. For general ledger reporting, it could show the selected account, posting period, actual amount, budget amount, and variance.
The same principle applies to management reporting. A Power BI Dashboard can use tooltip interactions to provide supporting information without filling the main dashboard with additional visuals. For executive reporting, a Power BI Executive Dashboard can use tooltips to give decision-makers additional financial context while preserving a focused presentation.
Business Central Reporting Use Cases
Tooltips are particularly useful when finance users need quick context around summarized Business Central data. On an accounts payable report, hovering over a monthly payment value could reveal supplier count, invoice volume, average invoice value, and payment timing. On a sales report, the tooltip could show customer segments, order quantities, discounts, and gross profit.
Procurement reporting can also benefit from contextual reporting. A procurement dashboard may connect spending information with a purchase order, approval status, supplier category, or department. A purchase requisition can provide additional context around requested spend, while the Power Automate Purchase Order Automation Guide can support broader understanding of purchase-order workflow design.
For approval-focused reporting, Power Automate Purchase Order Approval Workflows can complement dashboards that monitor requisition routing, approval stages, purchasing controls, and spend visibility.
Designing Effective Tooltips
The strongest tooltip designs are focused, consistent, and relevant to the visual being inspected. A finance team should first identify the decision supported by the main visual and then select supporting information that explains that decision.
- Use meaningful financial measures instead of duplicating the primary chart.
- Maintain consistent terminology across Business Central and Power BI reports.
- Use the same date, company, customer, vendor, and dimension logic as the primary visual.
- Keep the tooltip readable so users can understand the supporting information quickly.
- Test tooltip behavior across different filter selections and reporting periods.
Tooltips can also support narrative interpretation. Power BI Narrative Analytics can provide explanatory context around financial trends, while a tooltip can expose the specific supporting values behind a selected point.
Connecting Tooltip Insights With Finance Processes
Tooltip reporting becomes more valuable when the displayed indicators align with operational finance processes. For example, a cash management report can show vendor payment trends and provide contextual information around upcoming obligations. Late Payment Recommendations can support payment scheduling decisions by connecting vendor payment priorities with cash-flow objectives.
Accrual reporting can similarly connect summarized balances with approval information. A Flexible Workflow can support policy-driven approval workflows customized by business unit, department, and thresholds, helping finance teams manage accruals with greater precision. Where tax and industry-specific validation are relevant, the Hyperbots Platform can support workflows using line-level context and business rules.
Best Practices for Business Central Power BI Tooltips
Start with a clear reporting question, such as why revenue changed, which customers drive an overdue balance, or which department generated a spending variance. Build the tooltip around the supporting measures needed to answer that question.
It is also useful to keep tooltip calculations consistent with the primary report. A difference in date filters, currency treatment, posting logic, or dimension selection can make supporting figures appear inconsistent. Finance teams should therefore validate the Business Central data model, Power BI relationships, measures, and filter behavior together.
For procurement reporting, Power Automate Purchase Order Approval Workflows can provide contextual information around approval routing, while the broader Power Automate Purchase Order Automation Guide can help connect purchase-order reporting with procurement processes.
Summary
A Business Central Power BI Report Tooltip adds contextual financial information to Power BI visuals without overcrowding the main report. By using Business Central data, relevant measures, filter context, and purpose-built tooltip pages, finance teams can investigate revenue, expenses, receivables, payables, budgets, procurement, and operational metrics more efficiently. Effective tooltip design turns a summarized financial visual into an interactive reporting experience that supports faster analysis and better financial decisions.