Power BI Insights: Icon Map custom visual; Time intelligence; Adding external tools; Querying Amazon S3

August 3 2020

Power BI pros share their latest advice on the Icon Map custom visual, weekly time intelligence, adding external tools and querying Amazon S3.

Generating lines on a map with DAX, WKT and the Icon Map custom visual

Chris Webb doesn't often write about maps and geospatial tools, but in a recent blog post he shared his experiences working with the Icon Map custom visual. For the benefit of other users, he detailed how to display dynamically generated lines on a map. Getting started, he downloaded a latitude and longitude list of all of the cities in the UK, loading the data into four tables in Power BI.

Using the slicer tool, he set up the data so that users can select four different cities to draw lines between. He wrote:

The key to making this work is to use the Icon Map visual’s ability to display geometric data in Well Known Text format; documentation on this can be found here. To achieve this I wrote some (slightly over-engineered) DAX in a measure that generates a LINESTRING object that has four lines to connect the four selected cities…

Webb shared a PBIX file to get started and recommended that interested users check out a similar example by Mimoune Djouallah.

Time intelligence in Power BI

About MSDW Reporter

More about MSDW Reporter