Really Snapping to Grids in #Visio

Visio has the ability to refine the options for snapping shapes to just grids, but this does not necessarily mean that shapes will automatically position themselves on a grid, or that the size is a multiple of a grid. What if you want some shapes to always be positioned on a fixed grid, and the width and height to always be a multiple on the horizontal and vertical grids respectively? What if you want the grid to start at the top left rather then the default bottom left? Fortunately, the ShapeSheet of the page and shapes can provide this ability, without the need for any external code.

Read the rest of this entry »

Using EVALCELL() in #Visio to calculate Workdays

I recently agreed to calculate the number of workdays between two dates in Visio, without realising how difficult it is. Excel users are lucky because it has the NETWORKDAYS() function, but Visio users are not so fortunate. However, Visio does have the EVALCELL function which can be extremely useful in cases like this. I got the inspiration from one of the answers in StackOverflow for a SQL user who also needed a solution.

This slideshow requires JavaScript.

Read the rest of this entry »

Data Centre Racks in #Visio in #PowerBI

I have often diagrammed rack and cabinet layouts and elevations using Visio linked to a database or Excel tables. There is a Rack Diagram template in Visio which is great for manually creating cabinet elevations manually, but there is nothing currently out of the box to automate this process, so it can be a laborious task unless you have some custom code. It is quite simple to draw a computer room layout of the racks and cabinets and to link each one to a row of data. In this article, I have a table of rack equipment in Excel, and used PowerQuery in PowerBI to summarize these rows for each data center, rack and U height position, since there are sometimes more than one item of equipment per U height. In this example, I have color coded the criticality of each equipment such that the most important display as red, and the least important as green. This means that a PowerBI user can quickly see where the critical racks, U heights and equipment are. Of course, I could have used any metric, such as power consumption, heat output or humidity, for the colour-coding. It all depends on the data available, and the audience for the report.

This slideshow requires JavaScript.

Read the rest of this entry »

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

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

Smart graphics for visual people

Pluralsight blog

be smart, be clear, be visual ...