Skip to content
Tutorials Center
My learning

Topics

Lesson 36 of 56 ยท Visuals and Reports

Maps, Gauges and the Visual Formatting Options

Build and format Power BI maps, filled and shape maps, radial gauges, 100% stacked, area, donut, pie and ribbon charts, and learn the Format pane options they share.

Choosing the Right Visual tells you which chart fits which question. This lesson is the hands-on companion: how to build the map and gauge visuals that need extra setup, how the 100% stacked, area, donut, pie and ribbon charts are configured, and, because every one of these visuals is dressed up in the same Format pane, a tour of the options you will use again and again: legend, axes, data labels, colors, zoom slider, spacing, tooltips and header icons.

Power BI cannot run on this site, so the steps are described in text and the Python examples are stand-ins: matplotlib draws the same chart types from the same kind of table, so you can see what each configuration produces. The steps assume you have loaded a small table such as Employees with a name, department, city, state, salary and bonus.

The Format pane in one picture

Select any visual, then choose the Format visual icon (a paint roller) in the Visualizations pane. Settings are split into two tabs, Visual (the chart itself) and General (title, size, background, border, tooltip header icons), and most settings are collapsible cards. The names differ slightly between chart types, but the ideas repeat:

Card What it controls Good defaults
Legend Whether the series legend shows, its position (top, right, bottom), font and title Show it only when more than one series is drawn; put it at the top so it reads before the chart
X axis / Y axis Axis labels, font, title, start and end values, whether the axis is shown Start bar and column axes at zero; hide an axis whose values are already printed as data labels
Invert range Reverses the axis direction Rarely: only for a "rank" axis where 1 should be at the top
Data labels Printed values on the marks: display units (thousands, millions), decimals, position Use units such as K or M, one or two decimals at most
Colors The color of each series, or a gradient rule Use one color for a single series; use contrast, not rainbow
Spacing / Inner padding The gap between columns or bars, and the minimum bar width A gap about a third of a bar's width reads best
Lines (stroke width, line style) Thickness of a line and whether it is solid, dashed or dotted Dotted for forecasts or targets, solid for actuals
Zoom slider A slider under the axis that lets readers narrow the visible range Turn on for long time series
Title and Subtitle Visual title text, font, alignment, subtitle A title that states the question or the finding
Background, Border, Shadow Visual container styling Subtle: a light background or none
Tooltips What appears on hover; you can add a report page as a tooltip Add the measure(s) people ask about
Header icons The small icon row on a visual (filter, focus mode, more options) Hide on dashboards where readers should not use them

Two settings deserve a warning. Invert range reverses the axis, so higher values sit lower on the screen, which is almost never what a reader expects. And the zoom slider changes only the view, not the data: the filter pane stays the same.

If you like a configuration, copy it. Select the formatted visual, choose Copy on the Home ribbon, paste a second visual and swap the fields. Better still, use View > Themes or a JSON theme to set fonts and colors for the whole report (Formatting and Design).

100% stacked column and bar charts

A 100% stacked column (vertical) or 100% stacked bar (horizontal) chart gives every category the same height or length and shows how each is divided into parts. You compare shares, not totals.

To build one:

  1. Select the 100% stacked column chart visual.
  2. Put the category (for example Department) on the X-axis.
  3. Put the measure to split (for example Sum of Salary) on Y-axis.
  4. Put the sub-category (for example Bonus band or Gender) in Legend.

Merits: it makes mix changes obvious, for instance how the product mix moves each year. Demerits: the totals disappear (a small department looks as large as a big one), and only the bottom segment and the 100% line have a common baseline, so middle segments are hard to compare. Add the totals in a tooltip or a second visual.

Stacked area charts

A stacked area chart draws the series as filled layers on a continuous axis, usually time. Put the date on the X-axis, the measure on Y-axis and the series (such as Department) in Legend. The top edge is the total, and each layer is a series. Use it for a few series only: with ten layers nobody can read it. Remember that area charts imply a continuous variable, so the X axis must be a date or a number. Format options you will touch: the line width and stroke (a thin line separates layers), the fill transparency, the markers, and the zoom slider for long histories.

Ribbon, donut and pie

  • Ribbon chart: like a stacked column with ribbons that connect the segments of the same category across periods, and with the largest value always on top. Use it for rank changes. Put the date on X-axis, the measure on Y-axis and the category in Legend. In the Format pane, change the ribbon color (match series or gray), the spacing between columns and the ribbon transparency.
  • Donut chart: a pie with a hole. Put the category in Legend and the measure in Values. The Format pane has Slices (colors, one color per category), Detail labels (category, value, percent; label position inside or outside; font and color) and Rotation for the starting angle. A donut hole size (inner radius) slider changes how much of the center is empty: a larger hole leaves room for a total text box.
  • Pie chart: the same fields as the donut, without the hole. Both are suitable for two to five slices that add up to a whole; beyond that, sort the data and use a bar chart.

Radial gauge

A radial gauge (or gauge chart) shows a single value as the sweep of a needle between a minimum and a maximum, with an optional target mark. It resembles a car speedometer.

  1. Select the Gauge visual.
  2. Drop the measure to display (for example Sum of Completed Projects) into Value.
  3. Drop the goal measure (for example Sum of Target Projects) into Target value: the needle's goal marker. This sets the target line automatically.
  4. Optionally add Minimum value and Maximum value fields. If you do not, the gauge starts at 0 and the maximum defaults to twice the current value, so the scale moves whenever the data changes. Set them explicitly.
  5. In the Format pane, change the Gauge axis (min, max and target as fixed numbers when you do not have fields), the data colors (fill, background, target) and the callout value shown in the middle.

A gauge uses a lot of space for one number. Prefer a card with a KPI (Conditional Formatting and KPIs) unless you want the "speedometer" feel on an executive page.

Python Stand-in: 100% stacked bars, a stacked area and a gauge

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

In the 100% chart, IT's seniors take 64% of the department's salary and Sales' seniors take 73%. The bars have the same height even though Sales spends far more in total, which is exactly the trade-off described above.

Maps

Power BI has three families of map visuals. All three need geography, either a text field it can match (country, state, city, address, postal code) or latitude and longitude columns.

Visual Draws Fields
Map (bubble map) A bubble at each location; the bubble size shows a measure Location (or Latitude and Longitude), Legend (colors the bubbles by category), Size (the measure), Tooltips
Filled map Whole regions (countries, states, counties, postal codes) shaded by value Location, Legend or Color saturation (a measure that sets how dark the region is), Tooltips
Shape map A map built from a TopoJSON file, for custom or built-in regions (US states, a country's provinces) Location (matching the shape names), Color saturation

Build a bubble map. Choose the Map visual, drag City or State into Location, a measure such as Sum of Salary into Size, and Department into Legend. If a name is ambiguous (there are several towns called Springfield), add the country or use latitude and longitude and set the column data category (State or Province, City, Country) in the Column tools. Without the data category, Power BI may guess wrong.

Build a filled map. Choose Filled map, drag the geography column to Location and a measure to Color saturation. Regions with a larger value get a darker fill. Large regions dominate the picture, so normalize by population or area, or use a bubble map when the regions differ a lot in size.

Build a shape map. In some older versions the shape map is a preview feature that you must turn on first (File > Options and settings > Options > Preview features). It has two jobs: drawing standard boundaries that the filled map lacks, and drawing your own regions from a custom TopoJSON file. Add it, drag the location field into Location and a measure into Color saturation, then in the Format pane choose a built-in map (for instance US states or a country's subdivisions) or Add Map to load your own file. The location values must match the names in the map exactly.

Formatting a map

The Format pane for maps has a few cards that charts do not:

  • Map settings > Style (Road, Aerial, Dark, Light, Grayscale) and map controls: Auto zoom (fit the map to the data), Zoom buttons (show + and - controls), and Lasso button (select several points by drawing around them).
  • Bubbles (bubble map): size, color, transparency of the bubbles; Category labels to print the place name.
  • Fill colors (filled map and shape map): a diverging or gradient rule for Color saturation, with minimum and maximum colors, and a center value. Border color and width draw the region outlines.
  • Legend: position and font, as for charts.

Two cautions. Map visuals send location text to Bing for geocoding, and an administrator can disable them in the tenant settings, so check that your readers can see them. For a report that will be embedded or shown outside your company, test it. Second, in the service, maps behave the same, but filled maps need less precise geography than bubble maps: postal codes work in some countries and not others.

Python Stand-in: a tile map with color saturation

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

A real filled map does the same job with real boundaries: the measure you drop in Color saturation is normalized between the minimum and maximum colors you set. Notice how Texas, the highest value, is the darkest and the readable text color flips to white: in the Format pane you control the colors, not the label contrast, so check both.

Common mistakes

  • Using a donut or pie with a dozen slices. Switch to a sorted bar chart.
  • Leaving Y axis start automatic on a column chart, so a small change looks huge. Start at zero for bars.
  • Showing both data labels and gridlines and axis values: pick two at most.
  • Trusting a map whose location data category is not set, then finding a point in the wrong country.
  • Using a gauge with no explicit minimum and maximum, so the scale changes from refresh to refresh.
  • Forgetting the title, or keeping a legend for a chart with a single series.

Check your understanding

Quick check ยท 5 questions

of 5 answered You scored / 5 ยท perfect!

  1. 1. What does a 100% stacked column chart show best?

    Every column has the same height, so you compare the proportions of the parts, not the totals.
  2. 2. Which field on a gauge sets the goal marker?

    Target value draws the target mark. Value is the measure shown by the needle; minimum and maximum set the scale.
  3. 3. Which visual fills whole regions with a color that gets darker as a measure grows?

    A filled map shades regions by a measure placed in Color saturation. A bubble map draws circles at locations.
  4. 4. When would you choose a shape map?

    Shape maps use TopoJSON files, so they can draw regions that the standard filled map does not know.
  5. 5. What does 'Invert range' on an axis do?

    It flips the axis so larger values appear lower. Use it only for a rank-style axis where 1 should be at the top.

Summary

  • The Format pane shares cards across visuals: legend, axes, data labels, colors, spacing, line style, zoom slider, title, background, tooltips and header icons.
  • 100% stacked charts compare shares; stacked area shows layers over time; ribbon charts show rank changes; donut and pie suit two to five slices.
  • A radial gauge needs a value, a target value and explicit minimum and maximum.
  • Maps come in three kinds: bubble map, filled map (Color saturation) and shape map (custom TopoJSON). Set the data category of your location columns.
  • Choose what to show by question first, then configure the visual; that is the order used in Choosing the Right Visual.

Next: Formatting and Design.