How to Create an Inventory Dashboard in Power BI

Tired of manually checking spreadsheets to see what's in stock? Guessing about what to reorder and when? A dynamic inventory dashboard is your single source of truth, helping you avoid costly stockouts and prevent cash from being tied up in slow-moving products. This guide will walk you through building a powerful, real-time inventory dashboard in Power BI, step by step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why You Need an Inventory Dashboard

While spreadsheets can track basic stock counts, they often fall short. They're typically updated manually, prone to human error, and make it difficult to spot trends or answer deeper questions. A Power BI dashboard, on the other hand, connects directly to your data sources, updates automatically, and helps you visualize performance in ways a spreadsheet can't.

With an effective dashboard, you can:

• Prevent Stockouts: Get automated alerts when inventory levels for key products fall below their reorder points.
• Optimize Stock Levels: Identify overstocked items that are tying up capital and warehouse space.
• Improve Forecasting: Analyze sales velocity and historical data to predict future demand more accurately.
• Increase Profitability: Understand which products have the highest inventory holding costs versus their sales profit.

Step 1: Gather and Prepare Your Inventory Data

Before you even open Power BI, you need to know what data you're working with. A clean, well-structured dataset is the foundation of a great dashboard. Your primary data will likely come from an Excel or Google Sheet, an e-commerce platform like Shopify, or an ERP system.

At a minimum, your inventory dataset should include the following columns:

• Product ID / SKU: A unique identifier for each product.
• Product Name: The name of the product.
• Product Category: The group the product belongs to (e.g., "T-Shirts," "Mugs").
• Warehouse / Location: Where the stock is held if you have multiple locations.
• Quantity on Hand: The current number of units in stock.
• Unit Cost: How much it costs you to acquire one unit of the product.
• Unit Price: The price at which you sell one unit.
• Reorder Level: The stock quantity at which you need to reorder.
• Date of Last Receipt: The date you last received a shipment of this product.

Step 2: Connect and Transform Your Data in Power BI

With your data source ready, it's time to import it into Power BI Desktop. For this example, we'll assume your data is in an Excel file.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Connecting Your Data

From the Power BI Desktop home screen:

1. Navigate to the Home tab and click on Get data.
2. Select Excel workbook and click Connect.
3. Locate and open your inventory Excel file.
4. In the Navigator window, check the box next to the sheet that contains your inventory data and click Transform Data.

Clicking "Transform Data" opens the Power Query Editor, which is a powerful tool for cleaning and shaping your data before you build visuals.

Cleaning Your Data in Power Query

Inside the Power Query Editor, you should perform a few basic checks to ensure your data is ready for analysis:

• Check Data Types: Power BI is pretty smart at guessing data types, but it's always good practice to verify. For example, ensure 'Quantity on Hand' is a Whole Number, 'Unit Cost' is a Decimal or Fixed Decimal Number, and your date columns are set to the Date type. You can change the data type by clicking the icon to the left of the column header.
• Rename Columns: Make sure your column names are clear and easy to understand (e.g., change "Qty" to "Quantity on Hand").
• Remove Errors: Right-click a column's header and select "Remove Errors" to clean out any problematic cells that could break your visuals later.

Once you're happy with the structure, click Close & Apply in the top-left corner to load your prepared data into the Power BI model.

Step 3: Create Key Inventory Measures with DAX

Measures are calculations that help you summarize your data. You'll use a formula language called DAX (Data Analysis Expressions) to create them. These measures live in your model and can be used across multiple visuals. Don't worry, you don't need to be a DAX expert to start.

To create a new measure, right-click on your table name in the Data pane on the right-hand side and select New measure.

Here are a few essential inventory measures to get you started:

Total Inventory Value

This tells you the total cost value of all the stock you're currently holding.

Total Inventory Value = SUMX('Inventory', 'Inventory'[Quantity on Hand] * 'Inventory'[Unit Cost])

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Number of Items to Reorder

This measure counts how many distinct products have fallen below your preset reorder level.

Items to Reorder = COUNTROWS( FILTER( 'Inventory', 'Inventory'[Quantity on Hand] < 'Inventory'[Reorder Level] ) )

Stock Status (as a Calculated Column)

While most calculations should be measures, sometimes a calculated column is more useful. This one creates a simple text label for each product's stock status, which is great for filtering and in tables.

To create a calculated column, go to the Data View on the left, select your table, and click New column.

Stock Status = IF('Inventory'[Quantity on Hand] <= 0, "Out of Stock", IF('Inventory'[Quantity on Hand] < 'Inventory'[Reorder Level], "Reorder Required", "In Stock"))

Step 4: Build Your Dashboard Visualizations

Now for the fun part: visualizing your data. Drag your measures and data fields from the Data pane onto the report canvas to start building.

1. Headline KPIs with Card Visuals

Cards are perfect for displaying single, important numbers at a glance. You'll want cards for your most critical metrics.

• Drag the Card visual onto your canvas.
• Drag your Total Inventory Value measure into the 'Fields' well. Format it as currency.
• Create another card and use it to show your Items to Reorder measure.
• Create a third card to show the total Quantity on Hand (Drag the 'Quantity on Hand' column into the fields well and ensure it's set to "Sum").

2. Detailed View with a Table Visual

A table is essential for seeing the details. It's where you can list products that require immediate attention.

• Add a Table visual to your canvas.
• Drag the following columns into it: Product Name, Quantity on Hand, Reorder Level, Stock Status.
• Use the Filters pane to show only items where "Stock Status" is "Reorder Required" or "Out of Stock." This creates an actionable to-do list for your purchasing team.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Inventory Value by Category with a Bar Chart

A bar chart is great for comparing values across different groups. Use it to see which product categories are holding the most value in inventory.

• Add a Stacked column chart to your canvas.
• Drag Product Category to the 'X-axis' field well.
• Drag your Total Inventory Value measure to the 'Y-axis' field well.

This chart immediately shows you where most of your investment lies, which can help you decide where to focus cost-saving efforts.

4. Interactive Filters with Slicers

Slicers make your dashboard interactive, allowing you to filter the entire report with a single click.

• Add a Slicer visual.
• Drag the Product Category column into it. This will let you analyze specific categories.
• Add another slicer for Location if you have multiple warehouses.
• Add a third slicer using your calculated column, Stock Status, allowing users to quickly see all "In Stock" or "Reorder Required" items across the entire dashboard.

Step 5: Refine and Share Your Dashboard

Once your visuals are in place, take time to refine the layout and design.

• Arrange your visuals logically. Place high-level summary cards at the top, with more detailed charts and tables below.
• Use clear titles. Rename each visual to describe exactly what it shows (e.g., "Inventory Value by Product Category").
• Add color wisely. Use conditional formatting in your table to highlight rows where stock is dangerously low. For example, make "Out of Stock" rows red and "Reorder Required" rows yellow.
• Publish and schedule refresh. Once complete, publish your report to the Power BI service. There, you can schedule a daily automatic refresh so your dashboard is always showing the latest data without any manual work.

Final Thoughts

Building an inventory dashboard in Power BI transforms your raw stock data from a static list into a dynamic decision-making tool. This overview provides the foundation for you to start monitoring stock levels, identifying trends, and ensuring you always have the right products on hand to meet customer demand.

While Power BI is a dominant tool for in-depth, custom BI, its learning curve can be steep for those who aren't data professionals. For marketing, sales, and e-commerce teams that need instant insights, we built Graphed to remove this friction. It lets you connect data from sources like Shopify, Google Analytics, or Salesforce and create real-time dashboards just by describing what you want to see - no data modeling or DAX required. You can simply ask, "Show me my current stock value by product category compared to last month," and get a live dashboard in seconds.