How to show polygon data in Power BI: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 12: | Line 12: | ||
|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. | ||
|The Icon Map should now show a map, but not yet the shapes of the neighborhoods. | |The Icon Map should now show a map, but not yet the shapes of the neighborhoods. | ||
|Select the "Format your visual" tab and unfold the GeoJSON section. | |Select the "''Format your visual''" tab and unfold the GeoJSON section. | ||
|Click on the Off button to activate it. | |Click on the Off button to activate it. | ||
|Switch to the Tygron Client Application to a Neighborhood GeoJSON endpoint. | |Switch to the Tygron Client Application to a Neighborhood GeoJSON endpoint. | ||
Line 18: | Line 18: | ||
|Hover over Administrative and under Neighborhoods, select [[Export Geo data]]. | |Hover over Administrative and under Neighborhoods, select [[Export Geo data]]. | ||
|In the Export Geo Data panel, set the type to GeoJSON (MultiPolygons). | |In the Export Geo Data panel, set the type to GeoJSON (MultiPolygons). | ||
|Verify that the export CRS is set to '''4326'''. If not, click on the edit link. | |Verify that the export CRS is set to '''4326'''. If not, click on the ''edit link''. | ||
|In the CRS selection panel, type '''4326''' and press enter. | |In the CRS selection panel, type '''4326''' and press enter. | ||
|Wait for the process to finish and select the WGS84 CRS with the number '''4326''' and confirm with select. | |Wait for the process to finish and select the WGS84 CRS with the number '''4326''' and confirm with select. | ||
|Click on the Copy URL button next to GeoJSON endpoint. | |Click on the ''Copy URL'' button next to GeoJSON endpoint. | ||
|Switch back to Power BI and paste the link in the URL field in the GeoJSON we had previously activated. (Use CTRL-V) | |Switch back to Power BI and paste the link in the URL field in the GeoJSON we had previously activated. (Use CTRL-V) | ||
|The [[Neighborhoods]] should now be visualized in the Icon Map as shapes. | |The [[Neighborhoods]] should now be visualized in the Icon Map as shapes. |
Revision as of 09:18, 14 December 2023
'"`UNIQ--youtube-00000000-QINU`"'
How to show polygon data in Power BI:
- Open or create a Power BI project that has a web connection to Neighborhoods of a project session. See this How-to;
- Select the visuals tab in your Power BI Project
- Click on the triple dots icon named "Get More Visuals" and select the option "Get More Visuals".
- In the search field, type "Icon" and select the "Icon Maps" app.
- On the Icon Map app page, click on the "Add" button.
- Unfold the "Neighborhoods" data connection
- 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.
- The Icon Map should now show a map, but not yet the shapes of the neighborhoods.
- Select the "Format your visual" tab and unfold the GeoJSON section.
- Click on the Off button to activate it.
- Switch to the Tygron Client Application to a Neighborhood GeoJSON endpoint.
- Select Current Situation in the Ribbon bar
- Hover over Administrative and under Neighborhoods, select Export Geo data.
- In the Export Geo Data panel, set the type to GeoJSON (MultiPolygons).
- Verify that the export CRS is set to 4326. If not, click on the edit link.
- In the CRS selection panel, type 4326 and press enter.
- Wait for the process to finish and select the WGS84 CRS with the number 4326 and confirm with select.
- Click on the Copy URL button next to GeoJSON endpoint.
- Switch back to Power BI and paste the link in the URL field in the GeoJSON we had previously activated. (Use CTRL-V)
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.