#PowerApps in #PowerBI with #Visio!!!

I am very excited to see that the preview for PowerApps in PowerBI has been released ( see Announcing availability of PowerApps custom visual for Power BI (preview) ). I saw this demonstrated months ago, and have been waiting impatiently ever since. Every time I have embedded a Visio diagram into PowerBI, I have wanted to display the selected shape data in a detail view … and now I can!

I cannot yet create a PowerBI report with the embedded PowerApps visual for consumption by the whole internet, but it should still solve many scenarios for organisations. I quickly added the new PowerApps visual to my example synchronised Org Chart and Desk Layout from my previous article ( #Visio in #PowerBI for viewing personnel hierarchies and locations ) , and recorded a simple selection in the following gif:

Selecting a Person.gif

Read the rest of this entry »

#Visio in #PowerBI for viewing personnel hierarchies and locations

My last article, Aliasing Data Columns for #Visio Organization Chart Wizard , mentioned the slight anomalies in the default Shape Data rows for the Organization Chart shapes and the Resources / Person shape. This prompted me to create an alternative view of the same data that can be linked to the Person shapes on a floor plan, and then to use the preview Visio Custom Visual in Power BI to display both views of personnel synchronised by the same data. This demonstrates how easy it is to create an effective dashboard for locating personnel locations and their position within an organisational hierarchy at the same time!

This slideshow requires JavaScript.

View the Power BI report online : Org Chart and Personnel Locations in PowerBI

Read the rest of this entry »

Aliasing Data Columns for #Visio Organization Chart Wizard

One of the most frequently used components of Visio is the Organization Chart Wizard (OrgChWiz), but it is also one of the most frustrating because of its apparent inflexibility. I was recently asked how to use different table column names with the wizard because the originating ODBC source could not be touched. Well, I have previously used Access to modify and enhance tables in this situation, but the OrgChWiz is quite old, and does not like using the newer Access queries as a data source unfortunately. If the basic table column names do not match the default column names in the organization chart shapes, then there may be superfluous Shape Data rows created on each shape and the ability to change the shape style is compromised, and the Shape Data rows get quite confused!

This slideshow requires JavaScript.

Read the rest of this entry »

Free #Visio training videos

This blog of mine is all about Visio, and is aimed at intermediate, power users and developers. For the less advanced Visio users, or too back fill some skills, then please check out the free Microsoft Visio training available from here : Visio video training

Happy holidays!

PS Packt’s $5 sale is now on! Grab my title Mastering Data Visualization with Microsoft Visio Professional 2016 for just $5 at Packt $5 deal

 

Cyber Monday giveaway free #Visio Chess

Earlier today, I gave away checkers for Visio (see Cyber Monday free #Visio Checkers! ) , and now this article completes my Cyber Monday freebies with a downloadable chess set for Visio!

This slideshow requires JavaScript.

Read the rest of this entry »

Cyber Monday free #Visio Checkers!

As it is Cyber Monday, I thought I would give away a compelling checkers board for Visio! In the UK, we call it Draughts, but the rules are the same… in my last post, I showed how to create a chess/checkers/draughts board, and in this one I add some checkers that can glue to the dark squares only!

This slideshow requires JavaScript.

Read the rest of this entry »

What is the minimum number of rectangles in a #Visio chessboard?

This may sound like a simple question with a definite answer, but I think it is worthy of further explanation. I wanted to make a chessboard shape with as few lines as possible, because it makes the shape more efficient and easy to work with. Some might consider grouping 64 squares together, but that would be a very heavy shape. A chessboard needs to appear to have 64 squares, but the following shape only has 9 rectangles … How is this possible?

ChessboardRectangles

Read the rest of this entry »

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

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