I like linking data to shapes in Visio. It saves time in filling in Shape Data and adding text, or any Data Graphic to them. Basically I am lazy, and I also like to create macros for repetitive tasks, so in this blog I provide two macros to save the drudgery of two tasks I do so often:
I have recently been demonstrating how to automatically drop data point shapes into the correct latitude \ longitude position over a map image in Visio, and in this instalment I show how to automatically filter the dropped data points by a rectangular area. This will only work after calibrating the map image as in my previous article https://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ and then using the Data Point shape (or similar) from https://blog.bvisual.net/2015/05/27/distributing-data-points-automatically-on-maps-in-visio/
The principles of reading the Shape Data value from a selected shape to automatically drop rows from the active External Data window using the selected master shape could be applied to many scenarios.
Want to learn the simple way?
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
be smart, be clear, be visual ...
Personal views on Dynamics 365 for Operations and Technical Architecture.
Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query
Microsoft Office 365 Development, and more...
Automate, Accelerate, Accurate
Life with Visio and other Microsoft Toys!
Windows Server Essentials Tips & Tricks
Just another WordPress.com weblog
be smart, be clear, be visual ...
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.
Smart graphics for visual people
Tips & Tricks around Mapping and Cloud Computing
be smart, be clear, be visual ...
