#Visio in #PowerBI for viewing personnel hierarchies and locations

My last article, Aliasing Data Columns for #Visio Organization Chart Wizard , mentioned the slight anomalies in the default Shape Data rows for the Organization Chart shapes and the Resources / Person shape. This prompted me to create an alternative view of the same data that can be linked to the Person shapes on a floor plan, and then to use the preview Visio Custom Visual in Power BI to display both views of personnel synchronised by the same data. This demonstrates how easy it is to create an effective dashboard for locating personnel locations and their position within an organisational hierarchy at the same time!

This slideshow requires JavaScript.

View the Power BI report online : Org Chart and Personnel Locations in PowerBI

I duplicated the queryOrg PowerQuery in Excel, as queryPersonnel, and slightly modified the naming of columns to match the Resources / Person master Shape Data row labels, as described in the previous article. I could then add data-linked Person shapes to the floor plan into the Space shapes that I had already added to it. These Space Plan add-on to Visio also includes Space and Category Explorer window which can be used to find a person by their name or by their location.

I used Power BI Desktop edition to get the queryOrg query from the Excel workbook, and created three aggregating queries for Department, Position and Manager. These were used to provide hierarchy slicers on the report.

I used the Visio Custom Visual and the Hierarchy Slicer from the Store in Power BI in addition to the standard Table visual.

I had to reduce the shape count on my office floor plan drawing, because the preview of the Visio Custom Visual for Power BI has a shape count limitation ( see Add Visio visualizations to Power BI reports for more information). This meant removing all of the furniture shapes that I has added over the top of the embedded CAD file. I also changed the color of the embedded CAD file layers to shades of grey, because I intended to use colors in Power BI. In fact, I grey-scaled all of the Visio shapes in the office plan and the organisation chart to provide greater contrast to the colors in Power BI. The embedded Visio Online visual in Power BI will automatically suppress and Data Graphics (Text Callouts, Icon Sets, Data Bars or Color by Value), but I removed them in the Visio file too because it must delay the display if Visio Online needs to hide them.

This slideshow requires JavaScript.

One key learning point for me is that the preparation of a Visio file for consumption by Power BI is different than that for printing or normal online viewing.

Related articles:

Aliasing Data Columns for #Visio Organization Chart Wizard

Adding clicks to infographics with #Visio visual for #PowerBI

#Visio custom visual preview for #PowerBI available for all!



4 Responses to “#Visio in #PowerBI for viewing personnel hierarchies and locations”

  1. #PowerApps in #PowerBI with #Visio!!! | bVisual - for people interested in Microsoft Visio Says:

    […] PowerApps visual to my example synchronised Org Chart and Desk Layout from my previous article ( #Visio in #PowerBI for viewing personnel hierarchies and locations ) , and recorded a simple selection in the following […]

  2. [Références] Power BI en posts – 2018 – Bonjour Joël Says:

    […] Visio in Power BI for viewing personnel hierarchies and locations […]

  3. Wim Says:

    Hi, is it possible to get the User’s Profile data in visio directly from Office 365, instead of importing the data from excel for example. Mainly the user’s picture should come from Office 365. Any change on Office 365 by the end user would reflect immediately in the floor plan or Org Chart in Visio.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query


Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

%d bloggers like this: