How to show Overlays in Power BI

From Tygron Support wiki
Revision as of 07:02, 14 December 2023 by Rudolf@tygron.nl (talk | contribs)
Jump to navigation Jump to search

Editor → Current Situation (Ribbon tab) → Overlays (Ribbon bar)
How to show Overlays in Power BI:
  1. Open or create a Power BI project that has a web connection to Neighborhoods of a project session. See this How-to;
  2. Select the visuals tab in your Power BI Project
  3. Click on the triple dots icon named "Get More Visuals" and select the option "Get More Visuals".
  4. In the search field, type "Icon" and select the "Icon Maps" app.
  5. On the Icon Map app page, click on the "Add" button.
  6. Unfold the "Neighborhoods" data connection
  7. Find and drag the features.properties.LONGITUDE and LATITUDE attributes to the corresponding Longitude and Latitude fields in the visual tab
  8. Find and drag the features.properties.NAME attribute to the Category field.
  9. Select a numerical property, such as feature.properties.ACTIVE and drag it to the Size field.
  10. The Icon Map should now show the neighborhoods center locations.
  11. Select the Format your visual tab and unfold the WMS Layer section.
  12. Click on the Off button to activate it.
  13. Switch to the Tygron Client Application to obtain the WMS Endpoint Url.
  14. Select Tools in the Ribbon bar
  15. Hover over API Overview and select Show WMS Endpoint. A Web browser opens.
  16. Copy the url stated in the OnlineResource element of the Service element.
  17. Switch back to the WMS Layer section of the icon map in Power BI.
  18. Paste the URL in the WMS URL field.
  19. Select the layer field and type 1. (This is the ID number for the Neighborhoods overlay)
  20. The Neighborhoods Overlay should now be visualized in the Icon Map.



Notes

  • Instead of an Overlay ID number, you can also use the WMS background layers.
  • To access a different timeframe for an Overlay, type the Overlay ID followed by a dash and then the timeframe number. For example: 14-3, 10-0 or 3-99.

How-to's

See also