I have used the Microsoft Visio Organization Chart Wizard many, many times over the years, but I usually use it from text files, and I had been aware that I was not getting good results from the Microsoft Exchange Server directory option, now that I use Office 365. I was always getting just the first Personnel record (Admin). Well, I was prompted to find out why, and was amazed to find the answer by Winnie Liang in Creating Organizational Chart from AD Information.[Read more…] about Using Visio Org Chart Wizard to work with Exchange Online
Microsoft Ignite 2019 at the huge Orange County Conference Conference Center in Orlando is over for another year. 30,000 attendees over 6 days, and I have seen my first sunlight today since I arrived in Florida last Saturday! So, it is time to review just what was announced about Visio, and how much Visio is appreciated.
I am upgrading this website at the moment, and I came across on old post of mine about a new video series that Microsoft launched in 2009 … yes, 10 years ago! So, I thought I wouldre-boot the series for all our enjoyment … and because almost all of the features are still present, with a new look, and some new features!
Clarity ep. 1: Create an Office Layout diagram using Visio[Read more…] about Clarity Videos Re-boot
So, I have created some macros to provide quick and easy selection, positioning and updating of images within a group shape.
[Read more…] about Replacing Images in Visio Shapes by Changing Data
I decided to present this article with VBA code rather than my preferred C# so that a stencil could be downloaded to provide instant usability, rather than having to install an add-in. It can be download from Image Utils.vssm, and should then be placed in to My Shapes folder, so that it becomes available to open in Visio. When it is opened, then the macros will need to be enabled.
There are just five public macros:
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!
View the Power BI report online : Org Chart and Personnel Locations in PowerBI
I duplicated the queryOrg in 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 VisioCustom 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.
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.
One of the most frequently used components of Visio is the Organization Chart Wizard (OrgChWiz), but it is also one of the most frustrating because of its apparent inflexibility. I was recently asked how to use different table column names with the wizard because the originating ODBC source could not be touched. Well, I have previously used Access to modify and enhance tables in this situation, but the OrgChWiz is quite old, and does not like using the newer Access queries as a data source unfortunately. If the basic table column names do not match the default column names in the organization chart shapes, then there may be superfluous Shape Data rows created on each shape and the ability to change the shape style is compromised, and the Shape Data rows get quite confused!
[Read more…] about Aliasing Data Columns for Visio Organization Chart Wizard
The Organization Chart template opens with the Belts – Organization Chart Shapes stencil open by default, although the Master shapes used can be replaced with those on one of the other nine using the Org Chart / Shapes gallery: