Skip to main content
  • EN

I would like to make a custom map for Power BI's Shape Map visualisation: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

 

When I make a TopoJSON with FME and open it in Power BI I see a completely filled square (basically the bounding box is filled). When I take the TopoJSON generated by FME and process it using the default paramaters of the online mapshaper tool (https://mapshaper.org/) by exporting as a TopoJSON the mapshaper TopoJSON file open's without a problem in Power BI.

 

When I compare the FME TopoJSON files to the mapshaper TopoJSON file using a text reader the only obvious difference that I see is that the parameters are in a different order, but the scale and transformation parameters are similar. I have attached the files to this message.

 

Any ideas on what I need to do with FME so that the outputted TopoJSON files will open in Power BI?

Hi @philipwhitten​ ,

Our development team has found that Power BI requires arcs and polygons in TopoJSON to be written in a clockwise manner. There is a parameter that controls orientation of areas in the TopoJSON writer and by default, this is set to counterclockwise. Try setting this parameter to clockwise and see if the file appears as expected in Power BI.

@debbiatsafe​  absolutelty brillian. Changing the orientation to clockwise resolves the problem. 😀

Reply


Community Stats

30,168
Posts
114,527
Replies
37,825
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.