How to use the Item Sales over Comparison Period report in Power BI for Microsoft Dynamics 365 Business Central

What the report reveals

The report connects the headline sales variance with the customers, products and salespeople behind it.

It also lets you test whether the change is driven by revenue, quantity, cost or profit, then save the view for future reviews.

How the Item Sales Comparison Report Starts the Investigation

Knowing that sales are down is not enough. The useful questions sit beneath the headline: are customers ordering less, has demand shifted away from particular products, is margin falling, or is the change concentrated in one part of the business?

The Item Sales over Comparison Period report in Business Central Insights brings those questions into one view. It compares two periods and lets you move from the overall variance to the customers, items and salespeople behind it. The video above demonstrates the controls; this article focuses on how to interpret the findings and turn them into a useful sales conversation.

A fair comparison comes first

Period comparisons are only meaningful when the dates provide the right context. A like-for-like view, such as the first six months of this year against the same six months last year, gives a straightforward picture of change. When the ranges differ, the adjusted comparison helps account for the number of days in each period.

That distinction matters because a dramatic-looking decline can sometimes be a date problem rather than a sales problem. Choosing the comparison deliberately gives managers a reliable starting point and prevents time being spent investigating a variance the calendar already explains.

Revenue is only one version of the story

The default view looks at Item Sales in local currency, but revenue alone can hide important changes in customer behaviour. The comparison can also be viewed by quantity, cost of goods sold, profit and other available measures.

Looking across measures turns a result into a diagnosis. Revenue may have increased because prices rose even though unit demand weakened. A product may be selling in greater volume while contributing less profit. The colour-coded variances make large movements easy to spot, but the chosen measure determines what those movements mean.

Find the declines that deserve attention

Not every movement requires intervention. The Customer Cliff and Item Cliff views surface material changes so the team can focus on the accounts and products that warrant a closer look.

Customer and item cliffs

The standard bookmarks highlight declines greater than 20 percent. You can begin with a customer and see which items account for the reduction, or start with an item and identify the customers buying less of it. Positive-growth views reveal where demand is strengthening and where there may be an opportunity to build on momentum.

Make the threshold fit the business

The 20 percent threshold is a useful starting point, not a universal definition of risk. A high-volume distributor may want to flag a relatively small change, while a business selling fewer high-value items may need a different rule.

The filter can be adjusted to match what is material in your organisation, including greater-than or less-than rules and combined conditions. The goal is to create a focused view of exceptions worth discussing.

Follow the variance to its commercial owner

A useful report should lead to a decision, not simply produce another chart. Combining fields such as area, item, customer and salesperson in a drill-down hierarchy connects a broad regional decline to the exact commercial relationship behind it.

Instead of telling a sales team that an area is behind plan, a manager can show that a particular customer reduced purchases of a particular item and identify the salesperson best placed to investigate. Other attributes, including location, model year, item characteristics or Business Central dimensions, can provide more context when needed.

When a view proves useful, save it as a bookmark and share it with colleagues. That gives the team a repeatable starting point for reviews rather than asking someone to rebuild the analysis each time.

Turn the result into the right question

The red percentage is not the conclusion. It is evidence that helps the business ask a better question.

A decline might reflect expected seasonality, a customer switching to a replacement product, a stock or delivery issue, competitive pressure, a lost relationship or a deliberate change in sales mix.

From insight to action

The report cannot have the sales conversation for the team, but it can show where that conversation should begin and provide enough detail to make it specific. That helps managers prioritise follow-up and gives account owners evidence they can act on.

Used in this way, the Item Sales over Comparison Period report becomes more than a retrospective dashboard. It turns changing sales patterns into focused questions, clearer ownership and timely action.

Explore Sales Insights for Business Central

See how pre-built Power BI reports can help your team analyse customers, items, salespeople, profitability and delivery performance.

Visit the Business Central Insights Sales page

Which Customers and Products Are Driving Your Sales Decline in Business Central?