Inventory Dashboard Using Basic DAX In Power BI

In this tutorial, I’m going to show you how to create a great inventory dashboard using some DAX formulas in Power BI. After properly setting up the data model, the next step is to write the DAX formulas and set up the visualizations for an inventory system in Power BI.

This tutorial will show the quick and effective ways to generate the information you need in your inventory dashboard.

Creating The Measures

First, create a measure table for your measures to be catalogued. Call it Key Measures.

1. Inventory Value

Next, create a new measure and call it Inventory Value. Use the SUM function to sum the Total Value.

dax inventory system

Drag the measure into the canvas and then add the Item Name from the Products table to the measure’s Axis. You’ll then get results from different products with a default theme.

2. Inventory Stock Quantity

Add a new measure, Inventory Stock Quantity, then sum up the Stock Quantity.

dax inventory system

For its visualization, copy and paste the previous chart and change its value to the new measure. Also, you need to sort the order by stock quantity.

If you’re trying to manage your inventory, you should manage it from a quantity perspective rather than a value perspective because you need to know the quantity that’s going out and how much you need to stock. You have to evaluate your products and stocks and start doing promotional analysis or marketing strategies for them.

Adding The Visualizations

You can also look at the table from a vendor perspective. Copy and paste the visualization and then change the Axis to Vendor.

Next, copy the same visual. Change the value to Inventory Value and then sort it by inventory value.

For the Inventory Stock Quantity by Item Name visual, change the value to Inventory Value and the Axis from Item Name to WarehouseCode to look at it from a warehouse perspective. Lastly, turn the visualization into a doughnut chart.

Add cards into the canvas with the values of Inventory Value and Inventory Stock Quantity.

The main thing that you’re doing with the visualizations is making simple calculations that quickly and easily give you different answers.

Turn the Inventory Value by Item Name visualization into a table and then add Inventory Stock Quantity in the values.

dax inventory system

Also, don’t forget to put the title. Add a textbox in the upper left corner and call in Inventory Value.

***** Related Links *****
Inventory Management Reports To Show Trends In Sales
Calculate Days Of Zero Stock – Power BI Inventory Management Insights
Inventory Management Insights With Power BI: Comparing Stock To Sales

Conclusion

You’ve now learned the basic DAX formulas and visualizations to use when creating an inventory dashboard in Power BI. This is already a great start to get valuable insights from your inventory data.

In the next tutorials, you’ll learn more complex DAX formula patterns to implement in your reports. This will allow you to extract more insights that will greatly aid the stock and sales analysis of your organization.

All the best,

Sam

Enterprise DNA Power BI On-Demand

The Latest

If you’ve been working with Python for data analysis or machine learning, you’ve likely come across NumPy arrays. They’re a powerful tool for handling numerical data, but sometimes, the data…

How to normalize a numpy array a quick guide.

Multiplying lists in Python is a common operation when performing mathematical computations or solving problems in data manipulation. There are multiple ways to achieve this task, depending on your requirements…

How to Multiply Lists in Python: A Simplified Guide

If you’ve been wrestling with Python lists and wondering how you can save them as a neat CSV file, you’re in the right place. One of the most common tasks…

How to Write a List to CSV in Python

Do you need to write an essay on the fall of the roman empire with accurate citations but have no time to find them? Are you tired of painfully having…

What is Caktus AI: A comprehensive overview

Pandas is a widely used Python library for data manipulation and analysis. One essential functionality that pandas can provide you is the ability to modify the structure of a dataset….

Pandas Drop Index: Efficiently Remove DataFrame Rows or Columns

Working with strings is a common task in Python. You often need to figure out whether a string contains another string. The simplest methods to check if a Python string…

7 Ways to Check if a Python String Contains Another

Ever found yourself knee-deep in Python files, struggling to import a module from a parent directory? If so, you’re in good company. Python’s import system can sometimes feel like a…

Python Import from Parent Directory: A Quick Guide

Data is the backbone of businesses these days, and having proof that you know how to handle and make the most out of data is a big deal in the…

Microsoft DP-500

In programming, you may encounter situations where a variable does not have a value. These instances are commonly represented by a special value known as null. Many programming languages, such…

Null Python: 7 Use Cases With Code Examples

Truncating a floating-point number in Python is a common operation that many programmers encounter in various applications. The process involves removing the decimal place of a float, leaving only the…

Python Truncate Flow: A Streamlined Approach for Efficient Code Execution

OpenAI’s ChatGPT tool has taken the world by storm and has been at the forefront of revolutionizing the way we generate content, do research, and even create code. And just…

Is ChatGPT worth it, let's work it out.

As you continue your journey as a Python programmer, you’ll want to write code that is more efficient, readable, and easy to maintain. The Python programming language comes with a…

Python Inline If: Simplify Your Conditional Expressions

Load More