How to show Overlays in Power BI: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(9 intermediate revisions by 2 users not shown)
Line 2: Line 2:


{{editor location|overlays}}
{{editor location|overlays}}
{{howto|title=show [[Overlay]]s in [[Power BI]]
{{howto|title=
 
|Open or create a Power BI project that has a web connection to [[Neighborhood]]s of a project [[session]]. See this [[How to access your project data in Power BI|How-to]];
|Open or create a Power BI project that has a web connection to [[Neighborhood]]s of a project [[session]]. See this [[How to access your project data in Power BI|How-to]];
|Select the visuals tab in your Power BI Project
|Select the visuals tab in your Power BI Project
Line 9: Line 10:
|On the Icon Map app page, click on the "''Add''" button.
|On the Icon Map app page, click on the "''Add''" button.
|Unfold the "Neighborhoods" data connection
|Unfold the "Neighborhoods" data connection
|Find and drag the features.properties.LONGITUDE and LATITUDE attributes to the corresponding Longitude and Latitude fields in the visual tab
|Find and drag the features.properties.'''LONGITUDE''' and '''LATITUDE''' attributes to the corresponding '''Longitude''' and '''Latitude''' fields in the visual tab
|Find and drag the features.properties.NAME attribute to the Category field.
|Find and drag the features.properties.NAME attribute to the Category field.
|Select a numerical property, such as feature.properties.ACTIVE and drag it to the Size field.
|Select a numerical property, such as feature.properties.ACTIVE and drag it to the Size field.
Line 24: Line 25:
|The [[Neighborhoods Overlay]] should now be visualized in the Icon Map.
|The [[Neighborhoods Overlay]] should now be visualized in the Icon Map.
}}
}}
{{gallery
|Icon_Map_app.JPG|Icon Map app page in Power BI app store.
|Icon_Map_visual.JPG|Icon Map visual button.
|Icon_Map_config_long_lat.JPG|Icon Map configuration for Neighborhoods visualized as center points.
|Icon_Map_long_lat.JPG|Icon Map with Neighborhoods visualized as center points.
|Show_WMS.JPG|Location in the Editor of the WMS Endpoint.
|Icon_Map_Format_Visual_WMS_timeframe.JPG|Icon Map Format Visual WMS Section with Overlay timeframe layer.
|Icon_Map_WMS_timeframe.JPG|Icon Map [[Heat stress Overlay]] timeframe 2.
|Icon_Map_Format_Visual_WMS_satellite.JPG|Icon Map Format Visual WMS Section with Satellite layer.
|Icon_Map_WMS_satellite.JPG|Icon Map Satellite Layer.
}}


{{article end
{{article end
|seealso=*[[Power BI]]
|howtos=
*[[WMS]]
* [[How to access your project data in Power BI]]
|notes=*Instead of an Overlay ID number, you can also use the [[WMS#Project Background Layers|WMS background layers]].
* [[How to show Indicator results in Power BI]]
*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 show polygon data in Power BI]]
|seealso=
* [[Power BI]]
* [[WMS]]
|notes=
* Instead of an [[Overlay]] [[ID]] number, you can also use the [[WMS#Project Background Layers|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.
}}
}}
[[Category:How-to's]]

Latest revision as of 16:15, 30 January 2024

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