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
 
(15 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 17: Line 18:
|Switch to the Tygron Client Application to obtain the WMS Endpoint Url.
|Switch to the Tygron Client Application to obtain the WMS Endpoint Url.
|Select [[Tools]]  in the Ribbon bar
|Select [[Tools]]  in the Ribbon bar
|Hover over API Overview and select Show WMS Endpoint. A Web browser opens.
|Hover over API Overview and select [[WMS|Show WMS Endpoint]]. A Web browser opens.
|Copy the url stated in the ''OnlineResource'' element of the ''Service'' element.
|Copy the url stated in the ''OnlineResource'' element of the ''Service'' element.
|Switch back to the WMS Layer section of the icon map in Power BI.
|Switch back to the WMS Layer section of the icon map in Power BI.
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=
|notes=*Instead of the ID number, you can also use the [[WMS#Project Background Layers|WMS background layers]].
* [[How to access your project data in Power BI]]
* [[How to show Indicator results in Power BI]]
* [[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.


  • Icon Map app page in Power BI app store.

  • Icon Map visual button.

  • Icon Map configuration for Neighborhoods visualized as center points.

  • Icon Map with Neighborhoods visualized as center points.

  • Location in the Editor of the WMS Endpoint.

  • Icon Map Format Visual WMS Section with Overlay timeframe layer.

  • Icon Map Heat stress Overlay timeframe 2.

  • Icon Map Format Visual WMS Section with Satellite layer.

  • Icon Map Satellite Layer.



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

Retrieved from "https://support.tygron.com/w/index.php?title=How_to_show_Overlays_in_Power_BI&oldid=58468"