Customer ABC Analysis in Power BI
See which customers make up 80% of your revenue and which bring in just 5%. The report ranks your entire customer base, plots a Pareto curve, and breaks A/B/C classes down by month, region, sales manager and product category. Class thresholds can be changed right in the report — no developer needed.
How the report splits customers into classes A, B and C
Customers are sorted by revenue from largest to smallest, and their cumulative share is calculated. Class boundaries are set by two thresholds, 80% and 95% by default. Both can be changed with slicers in the report header, and the whole report recalculates instantly.
Class A — up to 80% of revenue
Key customers your business relies on. Losing any of them shows up in the P&L. They need a dedicated manager, priority service and attention from leadership.
Class B — from 80% to 95%
The middle tier. This is where you look for growth candidates: customers who lack the product range, terms or contact they need to move up to A.
Class C — the remaining 5%
Small customers. Often the largest group by headcount, taking up a disproportionate share of sales managers' time. Standardised terms and automated service work best here.
What's inside the report
Two pages. The first, "Customer ABC analysis", gives an overall picture of revenue concentration. The second, "ABC analysis: breakdowns", shows how classes are distributed over time, by region and by category.
Class thresholds and period in the report header
The class A threshold (% of revenue), the class B threshold (cumulative %) and the year are selected with slicers. Want to look at your base using a 70/90 rule instead of 80/95? Two clicks, and the classification is recalculated across all visuals.
Concentration KPI panel
Five key figures: revenue, active customers for the period, average order value, number of class A customers and their share of revenue. At a glance, you see how dependent the business is on a narrow group of buyers.
Customer Pareto curve
Each point is a customer by revenue rank, and the colour shows the class. Dashed lines mark the 80% and 95% thresholds. The steeper the curve at the start, the higher the concentration — and the greater the risk of losing a large share of revenue along with just a few customers.
Revenue structure and customer ranking
A donut chart shows the A/B/C shares of revenue. Next to it is a table of all customers: rank, revenue, cumulative share, class, region and account manager. The table can be sorted and exported to Excel for the sales team.
Monthly revenue by class
The class is determined within each month, so you can see whether your core of A customers is stable, how the contribution of B and C changes, and where seasonal dips occur. Filters by region, sales manager and customer type narrow the view down to the slice you need.
Breakdowns by region, category and class
Customer mix by region and revenue by product category show the A/B/C shares in each breakdown. A summary table by class shows the number of customers, their share, revenue, revenue share and average revenue per customer in each class.
Who needs customer ABC analysis
Three roles that get the most value from a transparent view of the customer base.
Commercial director
Allocates the team's effort according to the real value of each customer. Sees how many class A customers each manager has and sets separate rules of engagement for every class.
Head of sales and regional managers
Filters the report by their region or manager and sees the customer ranking and monthly trends. Knows whom to retain first and who has the potential to move from B to A.
CEO and business owner
Assesses revenue concentration as a strategic risk. If 5 customers generate 15% of revenue, that is a board-level question, not just one for the sales department.
Where the report gets its data
ABC analysis needs only sales linked to a customer, a date and an amount. Region, sales manager, customer type and product category add the breakdowns.
Microsoft Dynamics 365
Accounts, invoices, orders and account managers. A native connection to Dataverse; data refreshes on a schedule with no manual exports.
ERP and accounting systems
Sales and shipments from BAS, 1C, Business Central or other ERPs via connectors or API. If needed, classes can be calculated by margin, not just by revenue.
Excel and SharePoint
If sales are tracked in Excel, we connect the files via Power Query. The report refreshes automatically when the files change in SharePoint or OneDrive.
Multiple sources at once
When customers live in the CRM and sales in the ERP, we combine them into a single model with a unified customer ID, so a class A customer is never split between systems.
Frequently asked questions
Can class thresholds be changed without a developer?
Why can a customer's monthly class differ from their annual class?
Can ABC be calculated by margin instead of revenue?
How often is the data refreshed?
Can ABC be combined with RFM segmentation?
Ready to launch ABC analysis?
Invest your resources where the return is highest
Knowing all your customers doesn't mean treating them all the same. ABC analysis in Power BI gives your team a clear map of priorities: whom to retain, whom to grow, and where to cut the cost of service.