Tag: Azure

Have you ever seen a bar chart on a map?

I prefer to call this visualization a skyscraper map because you can picture these bars on a map as skyscrapers.

You can use a skyscraper map for displaying geodata along values. The skyscraper map is a combination of a map with locations and a bar chart. The location can represent a city, a country, or some other type of place. As with a bar chart, the height or volume of each bar is proportional to the values it represents.

How to create a Skyscraper Map with Azure Maps in Power BI

First, you need to make sure that the Azure Maps preview feature is enabled in Power BI to create a skyscraper map. This tutorial is based on the Retail Analysis Sample dataset.

1    Click on the Azure Map icon of the Visualization pane.

2 Extend the filled map visual by dragging the lower right corner

3  Select PostalCode from the Fields Plane.

Power BI assigned Country to the Location field.

4  Select TotalSales from the Fields Plane.

Power BI assigned Sales to the Bubble size field.

5    Click on the Format your Visual section.

6          Disable the Bubble layer switch

7          Enable the Bar chart layer switch

8 Expand the Bar chart layer pane

9 Expand the Size pane

10  Select 4 px for Height

11  Select 3 px for Width

You created a skyscraper map that shows sales by zip codes in your data set. Download the PBIX file.

Learn how to create a #SkyscraperMap with #Azure Maps in #PowerBI 🌇
➡️ https://t.co/C4Spq2Ryda#100DaysOfData #visualanalytics #dataviz #BarChartMap pic.twitter.com/QV5XeanqYh

— Alexander Loth (@xlth) August 3, 2022

Some exciting new features in Power BI are not enabled by default. These functions are so-called preview features whose development or testing is not yet completely finished. For certain use cases, such as creating Skyscraper Maps in Power BI, it may be worthwhile to activate them.

In the following blog posts, we will check out some capabilities of the Azure Maps feature. Therefore, let’s see how you can enable Azure Maps, and other preview features, in Power BI.

1    Click on File in Power BI’s menu bar.

2    Click on Options and settings

3    Click on Options

4  Select Preview Features from the lefthand list.

5          Enable Azure map visual

6          Confirm your changes with the OK button

Power BI might ask you to restart the application in order to change the preview features settings. Now you’re good to go to create your Skyscraper Map with the Azure Maps feature!

Which preview features is Power BI offering?

While the preview features change over time, currently you can enable the following preview features in Power BI:

• Shape map visual
• Spanish language support for Q&A
• Q&A for live connected Analysis Services databases
• Azure map visual
• DirectQuery for PBI datasets and AS
• Modern visual tooltips
• Power Bl Desktop infrastructure update
• Web page connector infrastructure
• Modify visuals settings for mobile layout
• Sparklines
• Scorecard visual
• Field parameters

Learn how to enable Power BI’s Preview Features, such as #Azure Maps – and create fancy skyscraper maps 🌇#100DaysOfData #powerbi #visualanalytics #datavizhttps://t.co/Rxft2NHCDW

— Alexander Loth (@xlth) July 12, 2022