> For the complete documentation index, see [llms.txt](https://dyns.ntd.asia/power-dynamics/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dyns.ntd.asia/power-dynamics/power-platform/fabric-and-power-bi/leveraging-interactive-warehouse-floor-maps-in-power-bi.md).

# 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**