If you are one of the increasing number of Power BI users that have discovered that the Visio Visual gives you the great ability to include Visio diagrams in your dashboard, then you may have come across the following error, ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI’, when you try to embed a Visio document. This can be frustrating, but here is a deeper explanation of what is happening … and how you can usually overcome it.
Readers of my blog will know that I use the layers in Visio pages to change the display for different scenarios. My macro to toggle layers on/off has been very popular, and I have written an add-in to manage layers that is widely used. However, I was recently asked if the layer settings can be controlled from linked data. Linking data in Visio has been available in all desktop editions, except Standard, since 2007, and I have written many articles and two books extolling this feature, but I haven’t so far controlled layer settings with it, so this article describes how this can be done … as shown in the following screen recording!
I recently re-discovered an issue with callouts in Visio for a couple of projects that I am working on, and so I had to find a fix. The problem is that the callouts become dis-associated from their target shapes if either the layer visibility of the callout or the target shape is toggled off, and then back on again. This will result in a diagram with shapes without any connected callouts, so moving any of the target shapes will not move their associated callouts with them! I initially came up with a workaround that involved some jiggery-pokery with sub-shapes and layers, but it seems that the problem could have easily been averted if Microsoft had incorporated one specific User-defined Cell from the very start…
First, I should be clear which callouts I am talking about because the word has been used and abused over the years … This article refers to the callouts that are inserted from the Insert / Diagram Parts ribbon group. These are part of the Structured Diagrams concept that was introduced with Visio 2010.
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.
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
Well the secret is out … Microsoft are looking for beta testers for the initial release of Visio on iPad. Note, that this is view only, but it should offer a more faithful graphical representation than any third-party product. Plus, it has layer control!
Microsoft asks Insiders to comment in particular on the following iPad-specific features:
Sometimes I get really frustrated with Microsoft. They have a really great data-diagramming product with Visio, which they bought for the largest amount that they had ever paid for an acquisition at the time in 1999, but they have not succeeded in marketing the virtues of visual data to most of the Office community. I have always thought that one of the reasons for that is a misguided belief that you should not be able to make good use of Visio diagrams without purchasing Visio. My evidence for this is the lack of data, and sometimes hyperlinks, that are with each shape in the various outputs such as XPS, PDF, and Save As Web. For me, this is a missed opportunity because each of these formats could include data and multiple hyperlink support for each shape. Indeed, it should have been relatively simple for Microsoft to integrate Visio better with Word, Excel and PowerPoint … and I mean graphics and data, not just dumb pictures.
