# Leveraging Interactive Warehouse Floor Maps in Power BI

Recently, when I worked with my wife to draw her company's Warehouse Floor Map, it was exciting to me. Then, I think about how to show the Warehouse Floor Map as a visualization in the Power BI. That can help my wife track & analyze inventory on hand, finding items by Warehouse Location easily.

Using the Warehouse Floor maps in Power BI can greatly enhance data visualization and analysis for inventory management. Here's a brief outline of my article.

## 1. Source Files

I created a sample Warehouse Floor Map and Sample Dataset which is being used for my instance.

<table><thead><tr><th>File name</th><th data-type="files"></th></tr></thead><tbody><tr><td>Sample Inventory On-hand Data</td><td><a href="/files/OolFjyNXi4dS0pjtz4UY">/files/OolFjyNXi4dS0pjtz4UY</a></td></tr><tr><td>Sample Warehouse Floor Maps (Visio)</td><td><a href="/files/IaSVUbo6dmAyRYTOqY7F">/files/IaSVUbo6dmAyRYTOqY7F</a></td></tr><tr><td>Sample Warehouse Floor Maps (SVG) - <mark style="color:red;">Synoptic Designer</mark></td><td><a href="/files/ZHYpzw1A8aEq58rfLCDp">/files/ZHYpzw1A8aEq58rfLCDp</a></td></tr><tr><td>Sample - Power BI report file</td><td><a href="/files/6yPgSw2mGczZOj9Ex8jp">/files/6yPgSw2mGczZOj9Ex8jp</a></td></tr></tbody></table>

Now, I will describe my data sample - file "**Sampe\_DS.xlsx"**

<figure><img src="/files/398B8w7qoxf7RfAXbyLq" alt=""><figcaption><p>Overview - Sample Data</p></figcaption></figure>

Data Model in Power BI:

<figure><img src="/files/YgOqBPmKniWZmnaX0rbL" alt="" width="563"><figcaption><p>Power BI - Data Model</p></figcaption></figure>

## 2. Make a Warehouse Floor Map design for Power BI

In the Power BI, I found and used 2 visuals to make it.

* [Visio Visual](https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381132): You must create the Warehouse Floor Map Visio file\
  Sample Visio file for "Warehouse Floor Map" - each warehouse location is a <mark style="color:red;">**Shape with a unique Name.**</mark> This Shape Name will be used to map with the Warehouse Location in the data source file ***"Sample\_DS.xlsx"***<br>

  <figure><img src="/files/GiIXJhIqYixGwldWMGwg" alt=""><figcaption><p>Visio Design - Warehouse Floor Map</p></figcaption></figure>

  \
  \&#xNAN;*<mark style="color:red;">**Important:**</mark>* *Ensure that the **Visio shapes** that you want to link to Power BI data within your diagram have **unique text.***

* [Synoptic Visual](https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380873): You must make some areas for the Warehouse Floor Map image by using the Synoptic Designer at the link <https://synoptic.design/>.\
  \ <mark style="color:red;background-color:green;">**How to make an area for any image by Synoptic Designer?**</mark><br>

  <figure><img src="/files/dMwYNsryNxWEATZL7uBg" alt=""><figcaption><p>Make Area for Warehouse Location by Synoptic Designer</p></figcaption></figure>

  \
  *<mark style="color:red;">**Important:**</mark>* *Ensure that the **Area name** that you want to link to Power BI data within your image has **unique value.***

## 3. Create a Power BI report

## 3.1 Using Visio Visual

You must get Visio Visual first ***( ... > Get more visuals > Visio Visual).*** After that, we add this Viso Visual to the Report page and configure it as the image below.

<figure><img src="/files/74188bd2dXwetGn3NRIJ" alt=""><figcaption><p>Add Visio Visual in Power BI</p></figcaption></figure>

{% hint style="info" %}
Due to the Visio Visual connecting exclusively through URL, it's necessary to upload the completed Visio File to a cloud service (e.g., SharePoint, OneDrive) upon design completion.
{% endhint %}

**Configuration:**

{% embed url="<https://youtu.be/hBMjMOE9-nk>" %}
Add - Visio Visual
{% endembed %}

### 3.2 Add Synoptic Panel visual

Now we move to configure on another Visual - **Synoptic Panel.**

**Configuration:**

{% embed url="<https://youtu.be/1rXI1qyfYyA>" %}
Add - Synoptic Visual
{% endembed %}

That's all for my ideas.&#x20;

Thank you for watching & Hoping well! ... :goal::tada:\
\&#xNAN;**\[NTD]yns.asia**


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dyns.ntd.asia/power-dynamics/power-platform/fabric-and-power-bi/leveraging-interactive-warehouse-floor-maps-in-power-bi.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.