• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network

PowerQuery

Published on March 7, 2019 by David Parker

Bring real-world visualizations to Power BI with Visio

In just one week’s time, I will be presenting a webinar on embedding efficient and effective Visio visuals with Power BI. I will demonstrate how to create examples like this one at bit.ly/VisioDC:

This is the registration link so I hope you can attend!

Filed Under: PowerBI, Videos, Visio, Webcasts Tagged With: PowerQuery, Visio Online

Published on June 5, 2018 by David Parker

Data Centre Racks in Visio in PowerBI

I have often diagrammed rack and cabinet layouts and elevations using Visio linked to a database or Excel tables. There is a Rack Diagram template in Visio which is great for manually creating cabinet elevations manually, but there is nothing currently out of the box to automate this process, so it can be a laborious task unless you have some custom code. It is quite simple to draw a computer room layout of the racks and cabinets and to link each one to a row of data. In this article, I have a table of rack equipment in Excel, and used PowerQuery in PowerBI to summarize these rows for each data center, rack and U height position, since there are sometimes more than one item of equipment per U height. In this example, I have color coded the criticality of each equipment such that the most important display as red, and the least important as green. This means that a PowerBI user can quickly see where the critical racks, U heights and equipment are. Of course, I could have used any metric, such as power consumption, heat output or humidity, for the colour-coding. It all depends on the data available, and the audience for the report.

[Read more…] about Data Centre Racks in Visio in PowerBI

Filed Under: Network Diagrams, PowerBI, Visio Tagged With: Excel, PowerQuery, Shape Data

Published on January 6, 2018 by David Parker

PowerApps in PowerBI with Visio!!!

I am very excited to see that the preview for PowerApps in PowerBI has been released ( see Announcing availability of PowerApps custom visual for Power BI (preview) ). I saw this demonstrated months ago, and have been waiting impatiently ever since. Every time I have embedded a Visio diagram into PowerBI, I have wanted to display the selected shape data in a detail view … and now I can!
I cannot yet create a PowerBI report with the embedded PowerApps visual for consumption by the whole internet, but it should still solve many scenarios for organisations. I quickly added the new 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 gif:

To do this, I simply created a default new PowerApps app from the queryOrg query in  Excel workbook I created previously, and modified the Item value for the DetailForm of the DetailScreen. I removed the BrowseScreen and EditScreen because they were not required. Then, hey presto, the correct record is displayed whenever a shape is selected.

Selecting a Person.gif
[Read more…] about PowerApps in PowerBI with Visio!!!

Filed Under: PowerApps, PowerBI, Visio, Visio Online Tagged With: Excel, PowerApps, PowerQuery

Published on January 4, 2018 by David Parker

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!

[Read more…] about Visio in PowerBI for viewing personnel hierarchies and locations

Filed Under: Floor Plans, Org Charts, PowerBI, Visio 2016, Visio Online Tagged With: Excel, PowerQuery, Visio

Published on January 2, 2018 by David Parker

Aliasing Data Columns for Visio Organization Chart Wizard

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!


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:

[Read more…] about Aliasing Data Columns for Visio Organization Chart Wizard

Filed Under: Excel, Office 365, Org Charts, Shape Data, SQL Server, Visio 2016 Tagged With: Link Data to Shapes, Org Chart, PowerQuery, Visio

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in