I like Power BI, and the latest update features the ability to set a custom web url onto another column. So, I couldn’t resist trying it in the example below. Notice that the Country or Area values are hyperlinks to the url of the country page in the CIA World Factbook.
[Read more…] about Countries of the World in Power BI with FlagsDiagram Types
Using Visio Org Chart Wizard to work with Exchange Online
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
Visio news from MS Ignite 2019
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.
Clarity Videos Re-boot
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
Triggering Shape Mouse Enter and Leave JavaScript events in Visio Online
I am working on a project where Visio Online process diagrams are embedded within a SharePoint web page, and was surprised that the JavaScript onShapeMouseEnter() event was not being triggered as the mouse cursor moved over some of my shapes. After much searching by myself, and my colleague Seb Craft, we found that only the sub-shapes in the group were firing the event … So what was the problem?
Replacing Images in Visio Shapes by Changing Data
I wrote an article last year about Swapping Images in a #Visio Shape manually, but I want to be able to do this whenever a Shape Data value changes. This is because I use I invariably use shapes linked to data. I also want to be able to have multiple images within a single grouped shape, and all of them changing when their referenced Shape Data values change. I believe that this will be more adaptable for a lot of scenarios than trying to repurpose Data Graphic Icon Sets ( see Make Your Own Visio Data Graphic Icons Sets … automatically). I also discovered that the Shape.ChangePicture(…) function can just as easily work with urls as it can with network file paths, so even more possibilities are opened up! For example, the Visio Online JavaScript API has the ability to overlay an image (see ShapeView.addOverlay(…)).
So, I have created some macros to provide quick and easy selection, positioning and updating of images within a group shape.
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: