# ABC Analysis (Power BI Report)
INTRODUCED IN: Business Central 2026 release wave 1.
The ABC Analysis Power BI report ranks your inventory items into A, B, and C categories based on their sales amounts in local currency (LCY). Use the report to decide which items to always keep in stock and where you can afford occasional stock-outs. That way, you divert your supply chain resources to the items that matter the most.
The report calculates each item's share of total sales and classifies items by the percentage thresholds you define:
 Category A items have small volume and high value. These items drive the most revenue and should always be in stock.
 Category B items have medium volume and medium value.
 Category C items have high volume and small value. You might accept occasional stock-outs for these items.
Default category thresholds come from the ABC Analysis Setup page. See #set-up-abc-analysis-defaults. The same thresholds are also used by the Item - ABC Analysis (report)<reports/report-723>, so the classification is consistent across both reports. You can override the thresholds on the request page each time you run the report.
![Screenshot of the ABC Analysis Power BI report.]
## Use the report
Rank inventory items into A, B, and C categories based on their sales amounts (LCY) to identify high-value items and support purchasing and replenishment decisions.
Inventory managers use the report to:
 Identify the items that contribute the most to revenue and prioritize their availability.
 Review which items fall into each category and adjust purchasing strategies accordingly.
 Spot items with zero sales that might be candidates for phase-out or promotion.
Purchasing agents use the report to:
 Focus negotiations and supplier relationships on high-value Category A items.
 Adjust reorder quantities and safety stock levels based on item classification.
 Identify Category C items where you can reduce inventory investment.
Controllers use the report to:
 Analyze the distribution of inventory value across categories.
 Support decisions about inventory write-downs or obsolescence for low-value items.
 Validate that inventory investment aligns with sales performance.
## Set up ABC Analysis defaults
Before you run the report, you must set default category thresholds on the ABC Analysis Setup page. The three category percentages must add up to 100%.
1. Choose the ![Lightbulb that opens the Tell Me feature.] icon, enter ABC Analysis Setup, and then choose the related link.
2. Enter the percentage for Category A, Category B, and Category C. The values must total 100%.
3. Close the page.
The report uses these values as defaults. You can override them on the request page each time you run the report.
## Key performance indicators
The ABC Analysis report uses the following KPIs:
 inventory-powerbi-kpis#no-of-items-in-class
 inventory-powerbi-kpis#percent-of-sales-amount
 inventory-powerbi-kpis#sales-amount-abc
 inventory-powerbi-kpis#sales-quantity-abc
Select the link for a KPI to learn more about what it means, its calculations, and what data was used in the calculations.
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Data used in the report
The report uses data from the following tables in Business Central:
 Item
 Item Ledger Entries
 ABC Analysis Setup
## Try the report
Try the report here: ABC Analysis<https://businesscentral.dynamics.com?page=37111>
> TIP
> If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
## Related information
track-kpis-with-power-bi-metrics
Power BI Inventory app<inventory-powerbi-app>
Ad hoc analysis of inventory data<ad-hoc-analysis-inventory>
Built-in inventory and warehouse reports<inventory-wms-reports>
inventory-analytics-overview
Inventory overview<inventory-manage-inventory>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-powerbi-abc-analysis, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/inventory-powerbi-abc-analysis/
