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

Yesterday, I wrote about using #MSFlow with #Visio ( Updating data sources from #Visio using #MSFlow … easily! ), so it is fitting to announce that the Visio custom visual for PowerBI is now available from the Microsoft store, and that it works with PowerBI Desktop! This means that everyone can make use of my guidelines in my other recent article at Previewing the #Visio Custom Visual in #PowerBI !

This slideshow requires JavaScript.

Read the rest of this entry »

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.

This slideshow requires JavaScript.

Read the rest of this entry »

Anchoring scaled shapes to page corners in #Visio

I have read that other users have bemoaned the lack of a anchor to top left, or something similar in Visio, so I thought I would demonstrate the issue, then propose a solution. In particular, there are some master shapes on the Annotations and Title Blocks stencils in the Visio Extras category that you would expect to have this capability, but don’t. Wouldn’t it be useful to have the ability to keep the shape size and anchor position to page bottom left, bottom right, top right or top left? This would mean that the page size or scale could be changed, but the annotations and title blocks could remain anchored.

This slideshow requires JavaScript.

Read the rest of this entry »

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

Read the rest of this entry »

Embedding multiple language texts in one document in #Visio

A few years ago, I was asked to write an add-in for Visio that could switch the text in each flowchart shape between different languages. The client required 5 different alternate languages to be supported, and they had the same 99 page Visio document copied 5 times, and each time there was an edit to be done, then it had to be repeated in each document. So, I wrote an add-in that allows for multiple language texts and page names to be stored in a single document, and added the optional use of Bing Translator. Well, the Bing Translator is now Microsoft Cognitive Services Text Translator, and my add-in installer needed to be updated for later versions of Visio. I am pleased to say that it now works for all versions of Visio since 2010, and for all languages that Visio supports, and it can be downloaded and tried for 30 days from MultiLanguageText.aspx .

MLT01

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.

This slideshow requires JavaScript.

Read the rest of this entry »

Layer Manager add-in for Visio released

I use layers in Visio a lot. Maybe it is because I originally used CAD, and created facilities and cable management layouts linked to data. I know that some of my fellow Visio MVPS don’t use layers very much at all, mainly because they create process diagrams, I guess, but careful use of layers in a diagram can provide multiple views of the same base information. However, Visio has a more complex layering system than any CAD program that I used, so I have always created my own layer management tools. I have decided to package my utility together as an add-in that others may want to use too.

This slideshow requires JavaScript.

 

I have made some short videos explain the issue with layers in Visio, and how I solved it.

What’s the issue with layers in Visio?

Making it simple to toggle layer settings

Saving and recalling multiple layer settings easily

The add-in can be downloaded from my company website : LayerManager

I have put some licensing into the add-in, but 30 days are allowed for free.

Here is some of the genesis of this add-in : Toggling layers on and off

 

Chris Webb's BI Blog

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

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

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

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...