This blog post unpacks several considerations for when⚠️ NOT to use Power BI ⚠️ to create public engagement and communication tools. This is based on our recent experience working collaboratively with Charles Sturt University (CSU) to create a custom scripted public-facing online interactive tool to help communicate river and environmental flow data, and fish survey results across the Edward/Kolety-Wakool River system in southern New South Wales.
Read MoreDisplaying very detailed spatial files using WKT in the Icon Map comes with it’s challenges – the biggest being poor performance (i.e. very slow to render). Some simplification and reduction of precision can go a long way In this video blog I walk through some of my tips to simplify and reduce precision of your spatial files (using free tools such as QGIS and Map Shaper) BEFORE importing into Power BI as a WKT file to really improve rendering speed and avoid exceeding the 32,766 text character limit in Power Query. I hope this helps you have fun exploring maps in Power BI.
Read MoreSometimes we want to display highly detailed spatial files in Power BI using WKT text strings in the Icon Map custom visual… BUT Power Query has a text character limit of 32,766 characters per data point - so what can we do?!? In this video blog I walk through some Power Query and DAX magic to split up our WKT text string and then stitch it back together using CONCATENATEX. I also go over a very frustrating ‘gotcha’ where Power BI removes the lagging spaces in our text string on import (which causes errors in our WKT file) and how to resolve it. I hope this helps you have fun exploring maps in Power BI.
Read MoreIn this blog video I share a universal Power Query script for converting point data from easting/northing to latitude/longitude, which allows us to use this data in our Power BI mapping visuals.
Read MoreIn this short video blog we walk through how to create custom basemaps in MapBox and integrate them into your Icon Map in Power BI! We then take it to the next level by configuring dynamic basemaps which we can change using slicers. A big shoutout and thanks to James Dales for creating this awesome visual!!
Read MoreIn this short video blog we walk through how to take Icon Map to the next level by incorporating WKT to plot custom points, lines and polygons, including a quick overview of how to convert your spatial files to WKT in QGIS. A big shoutout and thanks to James Dales for creating this awesome visual!!
Read MoreIcon Map is hands down my favourite mapping visual for Power BI! In this short video I walk through how to get started creating your very first map with custom icons. A big shoutout and thanks to James Dales for creating this awesome visual!!
Read MoreWorking across the environmental industry – it’s fair to say that pretty much ALL of DiscoverEI’s Power BI reports have a map! And if you thought that MapBox was good, well you’re going to LOVE the Icon Map custom visual in Power BI – which allows you to display interactive polygons, points, lines and of course – icons, all in the one visual…plus so much more! To really appreciate how Icon Map can be used to visualize real world data, in this video blog I walk through two real-world applications of Icon Map to visualize environmental data. A big shoutout and thanks to James Dales for creating this awesome visual!!
Read MoreIn this post we walk through how to design your own custom MapBox Styles for Power BI and configure dynamic formatting to change styles based on your zoom level! As featured on PowerBI.Tips
Read MoreIn this post we walk through how to configure ‘drill down’ maps using the MapBox visual in Power BI, to dynamically uncover different layers of your spatial data hierarchy! As featured on PowerBI.Tips
Read More
In this post we walk through how to create awesome 3D maps using the MapBox visual in Power BI to design maps that WOW! As featured on PowerBI.Tips
Read MoreIn this post we walk how to get started using the MapBox custom visual in Power BI, from creating an account, to a tour of the MapBox Studio and how to create a circle and custom chloropleth map! As featured on PowerBI.Tips
Read MoreIn this post we show how to find, modify and process your spatial files, in order to visualise them in Power BI using Shape Map.
Read More
