# Sales by item (Power BI report)
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
The Sales by Item report gives a clear picture of your organization's item sales. It showcases key metrics for each item or item category. For example, the sales amount, quantities, and the cost amounts. You can break down the information further by the specific customers that buy the items.
![Screenshot of the Sales by Item Power BI report]
## Use the report
Leadership and management teams use the report to track item sales. Sales teams can use it to better identify key items.
CEOs might want a list of the top-selling items by revenue, and be able to compare the list with how much each item contributed to the company's overall revenue. You can use this information to make strategic decisions about which items to focus on and how to allocate resources.
Sales managers can identify items that aren't performing and implement sales promotions for them. You can also use this information to adjust inventory levels of different items, procure extra stock to assist with demand, or reduce stock levels for slower periods.
Salespeople can tailor their pitch based on the sales performance for specific items. The report lets you identify high-performing items. You can also use this report to gain insights on lower-performing items so salespeople can spot opportunities to up-sell or cross-sell.
## Key performance indicators
The report includes the following key performance indicators (KPIs) and measures:
 sales-powerbi-sales-kpis#sales-lcy
 sales-powerbi-sales-kpis#sales-quantity
 sales-powerbi-sales-kpis#adjusted-cost-lcy
 sales-powerbi-sales-kpis#cost-amount-non-inv
 sales-powerbi-sales-kpis#adjusted-profit-lcy
 sales-powerbi-sales-kpis#adjusted-profit-margin
Click on the link for a KPI to learn more about what it means, how it is calculated, 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:
 Sales Value Entries
 Sales Invoice Lines
 Sales Credit Lines
 Project Ledger Entries
 Item
 Item Category
## Try the report
Try the report here: Sales by Item<https://businesscentral.dynamics.com?page=37004>
> 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 your business KPIs with Power BI goals<track-kpis-with-power-bi-metrics>
Ad hoc analysis of sales data<ad-hoc-analysis-sales>
Built-in sales reports<sales-reports>
sales-analytics-overview
Sales overview<sales-manage-sales>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

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/sales-powerbi-sales-by-item, 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/sales-powerbi-sales-by-item/
