Adding clicks to infographics with #Visio visual for #PowerBI

Office 365 is a truly remarkable success story, but it is often difficult to understand what each of the parts actually do, or what it is actually in each edition. Microsoft are always adding applications and services to the various editions, or retiring ones that have been superseded. If I can’t see it, I can’t understand it, so I was very interested to see the Periodic Table of Office 365 infographic created by Matt Wade, a SharePoint guru who keeps an eye on these changes ( see ). It really helps in comprehending the current Office 365 applications and their purpose. Indeed, I have seen his graphic go through many iterations over the last few months, and it will continue to change. However, it was not clickable, and I am a visual data guy, so I contacted him, and offered to integrate his infographic into a Power BI now that the Visio custom visual is available. I then found out that there are several different language versions of his infographic out there on the web, translated by other SharePoint professionals in his network.

This slideshow requires JavaScript.

Matt agreed to let me have a go, so I created an Excel workbook of the group descriptions along with the translations of the application names, comments, etc. I created a worksheet for each language, but keeping English as the master one. I also created a table in Excel for the title information, and hyperlinks to the language versions and flag images.

I inserted the English infographic into a Visio page, and created simple transparent rectangle master shapes for an Element and Title. All that was remaining was to link the English language table from Excel in Visio, and drag and drop each row as an instance of the Element over their respective image. It was a easy task to duplicate the page for each language, and replace the underlying image, and save as unique Visio documents.

I then connected to the workbook in Power BI Desktop, and created queries to join the different language tables together, and created a relationship between language, elements and groupings. I could then use the new Visio custom visual to link the qElements query automatically to each rectangle because the Element column value equals the Title shape data value.

This slideshow requires JavaScript.

The Periodic Table of Office 365 infographic can now be panned and zoomed easily, and each of the elements can be clicked to display the grouping, information, and hyperlink automatically.

The initial English page in Power BI desktop could then be duplicated for each language, and all that needed to change was the page level filter, and the source Visio document.

This slideshow requires JavaScript.

I have been a Microsoft Most Valued Professional (Visio) for over 13 years, and producing Visio data solutions for more than 20 years, and am excited for the possibilities for self-service business intelligence dashboards utilising the Visio custom visual in Power BI. I will be showing off more #Visio / #Power BI / #PowerApps / #MSFlow integration at Microsoft Ignite ( #MSIgnite ) at the end of the month. See for more details.


See The Periodic Table of Office 365 in Power BI Data Stories at

The Microsoft Visio team have produced some documentation about the Visio visual for Power BI at

Quick link :


One Response to “Adding clicks to infographics with #Visio visual for #PowerBI”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

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

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another 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

Smart graphics for visual people

%d bloggers like this: