TMap

a drilldownable thematic map visual with linked polygon layers
for Power BI

Download Visuals

Version What is new Release date
TMap 2.1.0.0
  • Drill Down Donut Map, Choropleth Map, Bar Chart Map, Pie Chart Map and Stacked Bar Chart Map By Georegion's Names
  • Improved Display for WKT Polygon Layer
Released on September 9, 2023.
TMap 2.1.1.3
  • Improved choropleth map by using smart gradient
  • Optimized the placement of labels for marker layer to reduce overlapping
  • Improved selection and filtering out by polygon layer
Released on January 21, 2024.
Multi-pane Card 1.0
  • A Collapible Multipane Card Visual
  • Customized style for title bar and contents
Released on November 12, 2023.
Multi-pane Card 1.1
  • Data can be sorted by a specified column
  • Provided option to convert numbers to a human readable string
Released on January 7, 2024.

Most of the functions are free. For the functions needed additional purchases, a watermark "Free Trial" and/or a banner with a link to upgrade your license will appear on the visual.

If you decide to purchase them, you can buy them for using in the environments that support license management or license enforcement such as Power BI service via Microsoft AppSource. if you want to use them in the environments that don't support license management or license enforcement such as Power BI report server, please contact: sales@mylocs.ca

Download Boundary Data in WKT Format

Data Description
World Administrative Boundaries Converted from Natural Earth's ne_110m_admin_0_countries dataset.
Canada Provincial Boundaries Converted from the OpenStreetMap dataset.
US State Boundaries Converted from the US Census Bureau’s cb_2018_us_state_20m dataset.
US County Boundaries Converted from the US Census Bureau’s cb_2021_us_county_20m dataset.
City of Toronto Ward Boundaries Converted from City Wards dataset in City of Toronto's Open Data Portal.

These data are free to use, but we don't guarantee their quality and accuracy. Natural Earth's data is in the public domain, please find its Terms of use. OpenStreetMap data is licensed under the Open Data Commons Open Database License (ODbL). You can find the US Census Bureau’s open data policy from here. City of Toronto's open data policy can be found from here.

How to Convert a Shape File into Well-Known Text (WKT) Format

1. Load shape file into SQL Server

SQL Server Spatial Tool is a convenient tool to load a shape file into SQL Server database. It can be download from here. You can also use OSGeo4W Shell in QGIS to load a shape file into MS SQL Server, please see details from Alastair's blog.

2. Convert the geography column into Well-Known Text (WKT)

"STAsText" function in SQL server can be used to convert a geography column into Well-Known Text (WKT).

GeoColumn.STAsText()

3. Reduce the length of Well-Known Text (WKT)

Reducing the number of points in a polygon can improve performance for the TMap Visual. The syntax of the function "Reduce" in SQL server is as below:

GeoColumn.Reduce(tolerance)

The parameter "tolerance" must be a positive number. The larger the "tolerance" is, the more points will be reduced. We recommend that the length of Well-Known Text (WKT) is less than 10,000. Please note that reducing too many points will make a polygon becomimg point, linestring or geometrycollection.