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 http://icsh.pt/O365Table ). 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 https://myignite.microsoft.com/speaker/218253 for more details.

MSIgnite_TalkingTech

See The Periodic Table of Office 365 in Power BI Data Stories at https://community.powerbi.com/t5/Data-Stories-Gallery/Making-the-Periodic-Table-of-Office-365-responsive/m-p/248233

The Microsoft Visio team have produced some documentation about the Visio visual for Power BI at https://go.microsoft.com/fwlink/p/?linkid=851657.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

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 ...

%d bloggers like this: