• 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
    • 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
    • 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➡
      • 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
    • Visio blog on Orbus website
    • 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

Excel

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 August 15, 2017 by David Parker

Updating data sources from Visio using MSFlow … easily!

Most of my posts have been about using Visio as a data consumer by linking Visio shapes to data, but Visio can be the best place to create some data from. For example, an office layout can have personnel or equipment shapes within a workstation area, or space shapes are used to define areas which are used for calculating the space usage chargeback reports. There are non-facilities management related examples too, as the only consideration is what is the best way to create relationships, measure lengths, or calculate areas. These are all tasks that are best done by just moving, resizing, connecting or containing shapes interactively in the Visio interface. In this article I will explain how Microsoft Flow can be used update a data source simply from a Visio document.

[Read more…] about Updating data sources from Visio using MSFlow … easily!

Filed Under: MSFlow, Office 365, Visio Tagged With: Data Export, Excel, Shape Data, Shape Reports

Published on August 4, 2017 by David Parker

Previewing the Visio Custom Visual in PowerBI

It is time to talk about the new Visio custom visual for PowerBI. You may have read about it at Visio Power BI example and Add Visio visualizations to Power BI reports, but I wanted to add my findings. First, it is great to see this feature, but it is not yet the finished article. However, I hope I can show that it can be an extremely useful addition to the business intelligence toolset from Microsoft. I think that the existing Link Data to Shapes and Data Graphics features in Visio desktop are considered to be Operational Intelligence capabilities, whereas this new custom visual for PowerBI is definitely Business Intelligence. This is a different discipline, and I have been developing some guidelines for good practice when using Visio with PowerBI. In this article, I will demonstrate how I created a PowerBI dashboard using graphics and data from last years Microsoft Ignite conference.

VisioExcelPowerBI

Let me set the expectations because I am working with a preview of the Visio custom visual.

[Read more…] about Previewing the Visio Custom Visual in PowerBI

Filed Under: Excel, PowerBI, Visio 2016, Visio Online Tagged With: Excel, Visio, Web

Published on May 18, 2017 by David Parker

Data Visualizer for Visio Pro for Office 365 – Part 2

I walked though the steps to create a Cross-Functional flowchart automatically from an Excel table in my last article ( Data Visualizer for #Visio Pro for Office 365 – Part 1 ), but I often prefer to use a relational data source, such as Access or SQL Server, to store and organise my data. Therefore, I describe how Excel‘s Get Data (nee PowerQuery) can be used to merge together the data in a relational data source as a single table suitable for Data Visualizer in Visio Pro for Office 365.

[Read more…] about Data Visualizer for Visio Pro for Office 365 – Part 2

Filed Under: Access, Data Visualizer, Office 365, SQL Server, Visio Tagged With: Data Visualizer, Excel, Office365, Visio Pro for Office365

Published on May 18, 2017 by David Parker

Data Visualizer for Visio Pro for Office 365 – Part 1

Microsoft have just released Data Visualizer for Viso Pro for Office 365! This great new feature provides you with the ability to create diagrams from an Excel table automatically. It currently comes with two new templates for creating Basic or Cross-Functional flowcharts, but the feature can be used for many other different types of diagrams.

[Read more…] about Data Visualizer for Visio Pro for Office 365 – Part 1

Filed Under: Data Visualizer, Office 365, Visio Tagged With: Data Visualizer, Excel, Office365, Visio Pro for Office365

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • A Visio List Shape is also a Container
  • Taking Visio Actions Rows to the limit
  • TimeTable at RMConnect 2022
  • Custom Shapes in Visio in M365 and Web
  • A Multi-Time Zone Clock for Visio

Categories

Tags

Accessibility Add-Ins Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Pro for Office365 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

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • A Visio List Shape is also a Container
  • Taking Visio Actions Rows to the limit
  • TimeTable at RMConnect 2022
  • Custom Shapes in Visio in M365 and Web
  • A Multi-Time Zone Clock for Visio

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