Visualizations

Power BI's greatest strength lies in its ability to transform raw data into compelling visual stories. This chapter provides a comprehensive tour of every major visual type available in Power BI Desktop, explains when and how to use each one, and equips you with the formatting and design skills needed to build reports that inform, persuade, and delight your audience.

Visualization Overview

Why Visualizations Matter

Numbers in a spreadsheet can hide patterns. A well-chosen chart reveals trends, outliers, and relationships in seconds. Power BI provides dozens of built-in visual types — plus an ecosystem of custom visuals — so you can match the right visual to the right question every time.

Key benefits of effective visualizations:

Speed of insight — humans process images roughly 60,000 times faster than text.
Pattern recognition — trends, seasonality, and anomalies become immediately visible.
Communication — a single chart can replace paragraphs of narrative.
Decision support — stakeholders can act on visual evidence rather than gut feeling.

The Visualizations Pane

The Visualizations pane sits on the right side of Power BI Desktop and contains three areas:

Area	Purpose
Visual gallery	Icons for every available visual type (bar, line, pie, map, etc.). Click one to add it to the canvas.
Field wells	Drag fields from the Data pane into wells such as Axis, Values, Legend, Tooltips, etc. Each visual type has its own set of wells.
Format pane	Control colors, fonts, titles, borders, backgrounds, data labels, and every other formatting property. Accessed via the paint-roller icon.

How Power BI Renders Visuals

When you place a visual on the canvas, Power BI:

Reads the fields you assigned to each well.
Generates a DAX query behind the scenes (you can view it with Performance Analyzer).
Sends the query to the data model.
Receives the result set.
Renders the result using the visual's rendering engine (SVG for most built-in visuals, HTML/Canvas for some custom visuals).

Understanding this pipeline helps when troubleshooting slow visuals — the bottleneck could be the query, the model, or the rendering.

Visual Interactions

By default, clicking a data point in one visual cross-highlights other visuals on the same page. You can change this behavior to cross-filter (only show related data) or none (no interaction). Visual interactions are covered in depth in the Filters & Slicers chapter, but keep them in mind as you design multi-visual pages.

Bar and Column Charts

Bar and column charts are the workhorses of data visualization. They compare discrete categories using rectangular bars whose length encodes a quantitative value.

Types of Bar and Column Charts

Visual	Orientation	Best For
Clustered bar chart	Horizontal	Comparing categories side by side (e.g., revenue by region)
Clustered column chart	Vertical	Same as above; preferred when category labels are short
Stacked bar chart	Horizontal	Showing part-to-whole within each category
Stacked column chart	Vertical	Same as above, vertical orientation
100% stacked bar chart	Horizontal	Comparing proportions across categories (each bar totals 100%)
100% stacked column chart	Vertical	Same as above, vertical orientation

When to Use Each

Clustered — Use when you need to compare absolute values across categories. Works well with 2-4 series in the Legend.
Stacked — Use when you want to show both the total and the composition. Limit to 3-5 segments for readability.
100% stacked — Use when proportions matter more than absolute values. Great for survey results or market share comparisons.

Creating a Clustered Column Chart — Step by Step

Click an empty area on the canvas.
In the Visualizations pane, click the Clustered column chart icon.
From the Data pane, drag Product Category to the X-axis well.
Drag Sales Amount to the Y-axis well.
Optionally drag Region to the Legend well to split each category by region.
Resize the visual by dragging its corner handles.

Formatting Options

Select the visual, then click the Format icon (paint roller) in the Visualizations pane.

Setting	Location	What It Controls
Data labels	Format > Data labels	Show/hide values on bars, font size, color, display units (thousands, millions)
X-axis	Format > X-axis	Category label font, rotation angle, title
Y-axis	Format > Y-axis	Value axis range (auto or custom min/max), gridlines, display units
Legend	Format > Legend	Position (top, bottom, left, right), font, color
Colors	Format > Columns > Colors	Set individual or conditional colors per series or category
Title	Format > Title	Visual title text, font size, alignment, background
Border	Format > Border	Add a border around the visual with custom color and width
Background	Format > Background	Fill color and transparency behind the chart

Tips for Bar and Column Charts

Keep categories to 12 or fewer — beyond that, consider a Top N filter.
Sort by value (descending) rather than alphabetically for faster pattern recognition.
Use horizontal bars when category labels are long (e.g., product names).
Avoid 3D effects — they distort perception of bar length.

Line and Area Charts

Line charts connect data points with lines, making them ideal for showing trends over time. Area charts fill the space beneath the line, adding a sense of volume.

Types

Visual	Description	Best For
Line chart	Data points connected by lines	Trends over time, comparing multiple series
Area chart	Line chart with filled area beneath	Emphasizing magnitude of change over time
Stacked area chart	Multiple series stacked	Showing how parts contribute to a total over time
Line and stacked column chart	Combo visual	Comparing two related but differently scaled measures (e.g., revenue bars + margin % line)
Line and clustered column chart	Combo visual	Same as above, with clustered columns instead of stacked

Creating a Line Chart — Step by Step

Click an empty area on the canvas.
Select the Line chart icon from the Visualizations pane.
Drag a date field (e.g., Order Date) to the X-axis well.
Drag a measure (e.g., Total Revenue) to the Y-axis well.
Optionally drag a categorical field (e.g., Product Category) to the Legend well to create multiple lines.

Date Hierarchy Behavior

When you drag a date field to the X-axis, Power BI automatically creates a date hierarchy (Year > Quarter > Month > Day). You can:

Drill down through the hierarchy using the drill icons in the visual header.
Remove the hierarchy by clicking the small arrow next to the field name in the well and choosing the raw date field instead of the hierarchy. This gives you a continuous axis.

Trend Analysis Techniques

Technique	How to Apply
Trend line	Format > Trend line > Toggle on. Choose linear, exponential, logarithmic, polynomial, or moving average.
Forecast	Format > Forecast > Set forecast length (e.g., 3 months), confidence interval, and seasonality.
Constant line	Format > Constant line > Add a reference line at a fixed value (e.g., a target).
Average line	Analytics pane > Average line > Shows the average across all data points.

Combo Charts

Combo charts combine bars and lines in a single visual. They are useful when:

You have two measures on different scales (e.g., revenue in millions vs. profit margin as a percentage).
You want to show volume (bars) alongside a rate or ratio (line).

To create a combo chart:

Select the Line and clustered column chart icon.
Drag your primary measure to Column values.
Drag your secondary measure to Line values.
Power BI automatically creates a secondary Y-axis for the line measure.

Tips for Line and Area Charts

Use line charts for time-series data — they imply continuity over time.
Limit to 5 or fewer lines to avoid a "spaghetti chart."
Area charts work best with 2-3 series; more than that and the stacking becomes hard to read.
Use markers (Format > Markers) sparingly — they add clutter on dense time series.

Pie and Donut Charts

When to Use Pie Charts

Pie charts show part-to-whole relationships. Each slice represents a category's proportion of the total.

Use them only when:

You have 2-5 categories.
The differences between slices are large enough to see.
The audience expects a pie chart (e.g., market share).

Limitations of Pie Charts

Limitation	Explanation
Hard to compare slices	Humans are poor at judging angles and areas accurately.
Too many slices	More than 5-6 slices makes the chart unreadable.
No trend over time	Pie charts show a single snapshot; they cannot show change.
Similar-sized slices	When slices are close in size, differences are nearly impossible to see.

Better Alternatives

Instead of Pie Chart	Use This
Many categories	Treemap — handles dozens of categories with nested rectangles
Compare across groups	Stacked bar chart — easier to compare proportions side by side
Exact values matter	Table — shows precise numbers without visual distortion
Single dominant category	Bar chart with percentage labels — highlights the dominant category clearly

Creating a Donut Chart

A donut chart is a pie chart with a hole in the center. The hole can display a total or a KPI.

Select the Donut chart icon.
Drag a categorical field to the Legend well.
Drag a measure to the Values well.
Format > Inner radius to adjust the hole size.

Formatting Tips

Always add data labels showing both category name and percentage.
Sort slices from largest to smallest (clockwise from 12 o'clock).
Use distinct, accessible colors for each slice.
Consider adding a detail label showing the exact value alongside the percentage.

Scatter and Bubble Charts

Scatter charts plot individual data points using two numeric axes, revealing correlations and clusters. Bubble charts add a third dimension by varying the size of each point.

When to Use

Exploring the relationship between two measures (e.g., marketing spend vs. sales).
Identifying outliers (data points far from the cluster).
Showing distribution of data points across two dimensions.
Adding a third variable via bubble size (e.g., profit margin).

Creating a Scatter Chart — Step by Step

Select the Scatter chart icon.
Drag a measure to the X-axis well (e.g., Marketing Spend).
Drag a measure to the Y-axis well (e.g., Revenue).
Drag a categorical field to the Details well (e.g., Product Name) — this creates one dot per product.
Optionally drag a third measure to the Size well to create a bubble chart.
Optionally drag a categorical field to the Legend well to color-code bubbles by category.

Play Axis (Animation)

The play axis adds a time dimension to scatter charts:

Drag a date field to the Play Axis well.
Click the Play button that appears below the chart.
Watch data points move over time — great for showing how relationships evolve.

This feature is inspired by Hans Rosling's famous animated bubble charts and is excellent for presentations.

Clustering

Power BI can automatically group scatter chart data points into clusters:

Select the scatter chart.
Click the ellipsis (...) in the visual header.
Select Automatically find clusters.
Power BI uses a k-means algorithm to assign each point to a cluster.
A new field called Cluster appears that you can use in other visuals.

Formatting Options

Setting	Purpose
Category labels	Show the name of each data point next to its dot
Marker size	Control the base size of dots (for scatter) or the size range (for bubble)
Crosshair	Show crosshair lines on hover for precise value reading
Trend line	Add a linear or polynomial trend line to see the overall direction
Reference lines	Add constant lines to X or Y axis (e.g., target values)

Tables and Matrix

Table Visual

The table visual displays data in a flat, row-and-column format — similar to a spreadsheet.

When to use:

The audience needs to see exact values (not approximations from a chart).
You have many columns of detail data.
You want to combine with conditional formatting for a rich data grid.

Creating a table:

Select the Table icon from the Visualizations pane.
Drag fields into the Columns well in the order you want them to appear.
Resize columns by dragging the column borders in the visual.

Matrix Visual

The matrix visual is Power BI's pivot table equivalent. It displays data in a grid with row headers, column headers, and values — supporting hierarchies and subtotals.

Creating a matrix:

Select the Matrix icon.
Drag fields to Rows (e.g., Region > City).
Drag fields to Columns (e.g., Year > Quarter).
Drag measures to Values (e.g., Sales, Profit).

Matrix Features

Feature	How to Enable	Purpose
Subtotals	Format > Subtotals > Row/Column subtotals on/off	Show aggregated totals at each level of the hierarchy
Grand totals	Format > Subtotals > Grand totals on/off	Show totals at the bottom or right edge
Stepped layout	Format > Row headers > Stepped layout on	Indent child rows under parent rows (tree structure)
Expand/Collapse	Click the +/- icons on row headers	Allow users to expand or collapse hierarchy levels
Switch to tabular layout	Format > Row headers > Stepped layout off	Show each hierarchy level in its own column
Word wrap	Format > Column headers > Word wrap on	Wrap long header text instead of truncating

Conditional Formatting in Tables and Matrices

Conditional formatting transforms plain data grids into heat maps and scorecards. Access it by right-clicking a measure in the Values well and selecting Conditional formatting.

Available options:

Option	Description
Background color	Color the cell background based on value (gradient or rules)
Font color	Change text color based on value
Data bars	Add horizontal bars inside cells proportional to the value
Icons	Add icons (arrows, flags, circles) based on rules
Web URL	Turn cell values into clickable hyperlinks

Example — applying background color gradient:

Right-click the measure in the Values well.
Select Conditional formatting > Background color.
Choose Gradient as the format style.
Set the minimum color (e.g., light red), midpoint (white), and maximum color (green).
Click OK.

The table or matrix now shows a heat map where low values are red, mid values are white, and high values are green.

Card and Multi-Row Card

Card Visual

The card visual displays a single aggregate value prominently — perfect for KPIs like total revenue, customer count, or average order value.

Creating a card:

Select the Card icon.
Drag a measure to the Fields well.
The visual displays the aggregated value in large text.

Formatting options:

Setting	Location	Purpose
Callout value	Format > Callout value	Control font size, color, display units, decimal places
Category label	Format > Category label	Show/hide the field name below the value, font settings
Background	Format > Background	Add a background color behind the card
Border	Format > Border	Add a colored border
Shadow	Format > Shadow	Add a drop shadow for a raised effect

Multi-Row Card

The multi-row card displays multiple KPIs in a compact vertical list.

Creating a multi-row card:

Select the Multi-row card icon.
Drag multiple measures into the Fields well.
Each measure gets its own row with a label and value.

Formatting tips:

Adjust the card count (Format > Card) to control how many cards appear per row.
Use data labels and category labels to control font size independently.
Multi-row cards respond to filters and slicers, making them useful as a dashboard header showing KPIs for the selected context.

Practical Example — Executive KPI Header

Many dashboard designs place a row of cards across the top of the page:

Card 1	Card 2	Card 3	Card 4
Total Revenue: $12.4M	Gross Margin: 42.3%	Customer Count: 8,421	Avg Order Value: $1,472

To achieve this:

Create four separate card visuals.
Place them in a horizontal row at the top of the page.
Set the same background color and border for visual consistency.
Use the Align and Distribute tools (Format menu > Align) to space them evenly.

KPI Visual

The KPI (Key Performance Indicator) visual shows a metric, its trend over time, and its status relative to a target.

Components of a KPI Visual

Component	Field Well	Purpose
Indicator	Value	The measure you want to track (e.g., Revenue)
Trend axis	Trend axis	A date or sequential field to show the trend line
Target	Target goals	A measure or constant representing the goal

Creating a KPI Visual — Step by Step

Select the KPI icon from the Visualizations pane.
Drag your primary measure (e.g., Total Sales) to the Value well.
Drag a date field (e.g., Month) to the Trend axis well.
Drag a target measure (e.g., Sales Target) to the Target goals well.
The visual now shows the current value, a sparkline trend, and a color-coded indicator (green if above target, red if below).

Formatting

Setting	Purpose
Indicator > Direction	Choose whether "high is good" or "low is good"
Indicator > Transparency	Control the opacity of the trend area
Trend axis	Show or hide the trend line
Goals	Show or hide the distance to target

When to Use the KPI Visual

Executive dashboards where you need a quick status check.
Operational dashboards monitoring daily targets.
When you want to combine value, trend, and target in a single compact visual.

Gauge Visual

The gauge visual resembles a speedometer dial, showing where a value falls within a defined range.

Components

Component	Field Well	Purpose
Value	Value	The current measure (e.g., actual sales)
Minimum value	Minimum value	The lower bound of the gauge (defaults to 0)
Maximum value	Maximum value	The upper bound of the gauge
Target value	Target value	A reference line on the gauge

Creating a Gauge — Step by Step

Select the Gauge icon.
Drag your measure to Value (e.g., Actual Revenue).
Set Minimum value to 0 (or drag a field).
Set Maximum value to your stretch goal (e.g., drag Budget Revenue).
Drag your target measure to Target value (e.g., Target Revenue).

Formatting Options

Setting	Purpose
Gauge axis > Range colors	Set color bands (e.g., red 0-50%, yellow 50-80%, green 80-100%)
Callout value	Format the large number displayed inside the gauge
Target	Show/hide the target line and its value
Data labels	Show min, max, and target values around the gauge

Use Cases

Sales performance against quota.
Customer satisfaction scores (e.g., NPS from -100 to 100).
Manufacturing utilization rates.
Budget consumption (0% to 100%).

Caution

Gauge visuals take up significant canvas space for a single value. Consider whether a card visual with a conditional icon might communicate the same information more efficiently.

Maps

Power BI offers several map visuals for geographic data analysis. All built-in maps use Bing Maps as the underlying mapping engine.

Map Visual (Bubble Map)

Displays data as circles on a map. The circle size and color encode measures.

Field wells:

Well	Purpose	Example
Location	Geographic field	City, State, Country
Latitude	Latitude coordinate	40.7128
Longitude	Longitude coordinate	-74.0060
Size	Measure for bubble size	Sales Amount
Color saturation	Measure for color intensity	Profit Margin
Tooltips	Additional measures shown on hover	Customer Count

Step by step:

Select the Map icon.
Drag a location field (e.g., City) to the Location well.
Drag a measure (e.g., Sales) to the Size well.
Bubbles appear on the map sized proportionally to sales.

Filled Map (Choropleth)

Colors entire geographic regions based on a measure value.

Select the Filled map icon.
Drag a geographic field (e.g., State or Country) to the Location well.
Drag a measure to the Color saturation well.
Regions are colored on a gradient from low to high values.

Best for: Comparing values across clearly defined regions (states, countries, provinces).

ArcGIS Maps for Power BI

ArcGIS Maps provides advanced mapping capabilities from Esri:

Feature	Description
Reference layers	Add demographic or geographic overlays (e.g., average income by ZIP code)
Clustering	Automatically cluster nearby data points
Heat maps	Show density of data points
Drive-time analysis	Show areas reachable within a given drive time
Infographics	Display demographic data cards on the map

To use ArcGIS Maps:

Select the ArcGIS Maps icon in the Visualizations pane.
Sign in with an ArcGIS account (free or paid).
Configure layers, themes, and reference data.

Shape Map

The Shape Map visual uses TopoJSON files to render custom geographic shapes. It is useful for:

Custom regions not in standard maps (e.g., sales territories, floor plans).
Countries or regions where Bing Maps has limited data.

Steps:

Select the Shape map icon.
In Format > Shape, select a built-in map or import a custom TopoJSON file.
Drag a location field to the Location well (must match region keys in the TopoJSON).
Drag a measure to Color saturation.

Setting Up Geographic Data Correctly

Power BI geocodes text fields using Bing Maps. For best results:

Best Practice	Example
Use a data category	Set the column's data category to City, State, Country, etc. in the Data view
Be specific	"Springfield, IL" is better than "Springfield" (there are 30+ Springfields in the US)
Provide lat/long	For precise placement, include latitude and longitude columns
Separate components	Use separate columns for City, State, and Country rather than a single address field
Use standardized names	"United States" rather than "US", "USA", or "U.S.A." — or provide ISO codes

Treemap

A treemap displays hierarchical data as nested rectangles. The size of each rectangle is proportional to a measure value.

When to Use

You have many categories and a pie chart would be overwhelming.
You want to show part-to-whole relationships with hierarchical grouping.
You want to quickly identify the largest and smallest categories.

Creating a Treemap

Select the Treemap icon.
Drag a categorical field to the Category well (e.g., Product Category).
Optionally drag a subcategory to Category as well (e.g., Product Subcategory) for nesting.
Drag a measure to the Values well (e.g., Sales Amount).

Field Wells

Well	Purpose
Category	Defines the hierarchical groups (can stack multiple fields)
Values	The measure that determines rectangle size
Color saturation	An optional second measure that determines color intensity

Formatting Tips

Enable data labels to show category names and values.
Use color saturation to add a second dimension (e.g., size = revenue, color = profit margin).
Treemaps work best with 7-30 categories; fewer than 7 is better as a bar chart, more than 30 becomes hard to label.

Waterfall Chart

A waterfall chart shows how a starting value is increased or decreased by a series of intermediate values, leading to a final total. It is also called a bridge chart.

When to Use

Explaining how revenue builds from different product lines.
Showing the journey from gross revenue to net profit (subtracting costs).
Variance analysis (budget vs. actual by department).

Creating a Waterfall Chart

Select the Waterfall chart icon.
Drag a categorical field to the Category well (e.g., Cost Center).
Drag a measure to the Y-axis well (e.g., Profit Impact).
The visual automatically identifies positive (green) and negative (red) contributions.

Formatting

Setting	Purpose
Sentiment colors	Customize the colors for increase (positive), decrease (negative), and total
Breakdown	Enable/disable the subtotal bars
Data labels	Show the value on each bar
Category labels	Format the x-axis labels

Practical Example — Revenue Bridge

A waterfall chart can show:

Step	Value	Running Total
Starting Revenue	$10M	$10M
New Customers	+$3M	$13M
Upsell	+$1.5M	$14.5M
Churn	-$2M	$12.5M
Price Decrease	-$0.5M	$12M
Ending Revenue	—	$12M

The chart visually shows each positive addition floating upward and each negative deduction dropping downward, with the final bar grounded at the ending total.

Funnel Chart

A funnel chart displays a sequential process where items flow from one stage to the next, typically with decreasing values at each stage.

When to Use

Sales pipeline — leads > qualified > proposal > negotiation > closed.
Recruitment — applications > phone screen > interview > offer > hire.
Website conversion — visitors > page views > add to cart > checkout > purchase.

Creating a Funnel Chart

Select the Funnel chart icon.
Drag the stage field to the Category well (e.g., Sales Stage).
Drag the count or value measure to the Values well (e.g., Deal Count).
Power BI orders stages by value (largest at top, smallest at bottom).

Formatting Tips

Add data labels showing both value and percentage.
Use Conversion Rate Labels to show the drop-off between stages.
Consider using a horizontal bar chart if you need to label stages more clearly.

Important Note

Power BI sorts funnel stages by the measure value, not by the order they appear in your data. If your stages have a natural order (like a sales process), make sure the values decrease at each stage, or consider using a bar chart with manual sorting instead.

Decomposition Tree

The decomposition tree is an AI-powered visual that lets users interactively drill into data to find the root cause of a metric.

How It Works

Select the Decomposition tree icon.
Drag a measure to the Analyze well (e.g., Total Sales).
Drag multiple categorical fields to the Explain by well (e.g., Region, Category, Product, Salesperson).
The visual displays the total value and a + icon.
Clicking + lets the user choose which dimension to split by.
The AI option (High value or Low value) automatically selects the dimension that explains the most variance.

AI-Driven Analysis

When you select High value or Low value at any node:

Power BI evaluates all available dimensions.
It selects the split that produces the highest (or lowest) child node.
A lightbulb icon indicates an AI-selected split.
This is useful for finding the top contributor or worst performer in a complex dataset.

Use Cases

Scenario	Analyze	Explain By
Revenue deep dive	Total Revenue	Region, Product Category, Customer Segment
Cost investigation	Total Cost	Department, Cost Type, Vendor
Quality analysis	Defect Count	Production Line, Shift, Machine

Formatting

Bars — Each node shows a horizontal bar. You can format bar colors.
Data labels — Show values and percentages.
Tooltips — Add additional measures to tooltips for context.

Key Influencers Visual

The Key Influencers visual uses AI to analyze what factors most influence a selected metric.

Two Analysis Modes

Mode	Purpose	Example
Categorical	What influences a category value (e.g., what makes a customer churned vs. retained)	"Customer Segment is Enterprise" increases likelihood of churn by 2.5x
Continuous	What drives a numeric metric up or down (e.g., what increases average order value)	"Region is West" increases average order value by $120

Creating a Key Influencers Visual

Select the Key Influencers icon.
Drag the target field to the Analyze well (e.g., Churn Status).
Drag potential influencing fields to the Explain by well (e.g., Contract Type, Support Tickets, Tenure).
For categorical targets, select which value to analyze (e.g., "What influences Churn Status to be Yes").
The visual displays a ranked list of influencing factors with their relative impact.

Top Segments Tab

The Key Influencers visual includes a Top Segments tab that shows which combinations of factors create the highest concentration of the analyzed outcome. Each segment is displayed as a bubble, and clicking a bubble shows the segment's composition.

Tips

Include a variety of potential explanatory fields — the AI will determine relevance.
Works best with 100+ rows of data.
The visual uses logistic regression (for categorical) or linear regression (for continuous) under the hood.
Results are correlational, not necessarily causal.

Slicers as Visuals

Slicers are interactive filter controls that appear directly on the report canvas, giving users an intuitive way to filter data.

Slicer Types

Type	How It Looks	Best For
List	Checkbox list of values	Categorical fields with 5-20 values
Dropdown	Expandable dropdown menu	Categorical fields with many values (saves space)
Between	Two input boxes or a slider	Numeric ranges or date ranges
Relative date	Presets like "Last 7 days"	Date fields where relative filtering is needed
Hierarchy slicer	Expandable tree with parent/child	Hierarchical data (e.g., Country > State > City)

Creating a Slicer

Select the Slicer icon.
Drag a field to the Field well.
Power BI chooses the default slicer type based on the data type.
To change the slicer type, click the dropdown arrow in the visual header and select a different style.

Slicer Formatting Options

Setting	Location	Purpose
Single select	Format > Selection > Single select	Force users to pick exactly one value
Select all	Format > Selection > Show "Select all"	Add a "Select all" checkbox at the top
Search	Slicer header > Search icon	Enable text search within the slicer
Orientation	Format > General > Orientation	Switch between vertical and horizontal layout
Responsive	Format > General > Responsive	Automatically adjust layout when resized
Header	Format > Slicer header	Show or hide the slicer title, change font and size

Slicer Best Practices

Place slicers at the top or left side of the page for discoverability.
Use dropdown style for fields with many values to conserve space.
Add a "Reset filters" button using bookmarks (covered in the Filters chapter).
Group related slicers together (e.g., all date-related slicers in one area).
Use Sync Slicers to maintain slicer state across multiple pages.

Custom Visuals from AppSource

What Is AppSource?

AppSource is Microsoft's marketplace for Power BI custom visuals. It contains hundreds of free and paid visuals created by Microsoft and third-party developers.

Installing a Custom Visual

Method 1 — From the Visualizations pane:

Click the ellipsis (...) at the bottom of the Visualizations pane.
Select Get more visuals.
Search for the visual by name.
Click Add to install it.

Method 2 — From AppSource website:

Visit appsource.microsoft.com.
Search for Power BI visuals.
Download the .pbiviz file.
In Power BI Desktop, click the ellipsis > Import a visual from a file > select the file.

Popular Custom Visuals

Visual	Purpose	Key Features
Chiclet Slicer	Enhanced slicer	Image support, multi-select, flexible layout
Infographic Designer	Pictorial charts	Replace bars with icons (e.g., people, currency symbols)
Charticulator	Custom chart builder	Design entirely new chart types with drag-and-drop
HTML Content	Display HTML/CSS	Render custom HTML inside a Power BI visual
Deneb	Vega/Vega-Lite	Create Vega and Vega-Lite visualizations inside Power BI
Play Axis (Dynamic Slicer)	Animated filtering	Add a play button to cycle through slicer values
Gantt	Project timelines	Display project tasks with durations and dependencies
Bullet Chart	KPI comparison	Show actual vs target with qualitative ranges
Word Cloud	Text analysis	Display word frequency from text fields
Sunburst	Hierarchical data	Multi-level donut chart for nested categories

Organizational Visuals

Organizations can manage custom visuals centrally:

An admin uploads approved visuals to the Admin portal > Organizational visuals.
These visuals appear in a dedicated tab in the Visualizations pane for all users in the organization.
This ensures consistency and security — users do not need to install visuals individually.

Security Considerations

Concern	Mitigation
Custom visuals can access data	Only install visuals from trusted sources
Certified visuals	Look for the Microsoft Certified badge — these have passed additional code review
Data sent externally	Some visuals send data to external services (e.g., mapping APIs). Review the visual's documentation.
Organizational control	Use organizational visuals to restrict which custom visuals users can access

Conditional Formatting

Conditional formatting applies visual cues — colors, icons, and data bars — to visuals based on data values. It works on tables, matrices, cards, and some other visuals.

Accessing Conditional Formatting

Select a table or matrix visual.
In the Values well, right-click a measure.
Select Conditional formatting.
Choose from: Background color, Font color, Data bars, or Icons.

Format Styles

Style	How It Works	Best For
Gradient	Colors flow smoothly from min to max value	Heat maps, continuous data
Rules	Define specific rules (e.g., if value > 100 then green, else red)	Status indicators, threshold-based coloring
Field value	Use a column in your data that contains color hex codes	Pre-calculated colors from the data source

Background Color — Gradient Example

Right-click the measure > Conditional formatting > Background color.
Format style: Gradient.
Minimum: Light red (#FFC7CE).
Maximum: Light green (#C6EFCE).
Optionally set a midpoint color and value.
Click OK.

Background Color — Rules Example

Right-click the measure > Conditional formatting > Background color.
Format style: Rules.
Add rules:

Rule	Condition	Color
1	Value >= 90	Green
2	Value >= 70 AND value < 90	Yellow
3	Value < 70	Red

Click OK.

Data Bars

Data bars add horizontal bars inside table/matrix cells, similar to Excel's data bars.

Right-click the measure > Conditional formatting > Data bars.
Choose positive bar color and negative bar color.
Toggle Show bar only to hide the number and show only the bar.

Icons

Icons add visual indicators (arrows, flags, traffic lights, stars) next to values.

Right-click the measure > Conditional formatting > Icons.
Choose an icon style (e.g., traffic lights).
Define rules for each icon (e.g., green checkmark if >= 80%, yellow exclamation if >= 50%, red X if < 50%).
Choose icon position (left or right of value).

Applying to Cards

You can apply conditional formatting to card visuals to change the callout value color based on a rule. For example, turn the revenue card green when above target and red when below.

Select the card visual.
In the Format pane, find Callout value > Color.
Click the fx button next to the color picker.
Define rules or a gradient based on the card's measure.

Conditional Formatting Summary Table

Feature	Tables	Matrices	Cards	Bar Charts
Background color	Yes	Yes	No	No
Font color	Yes	Yes	Yes (via fx)	No
Data bars	Yes	Yes	No	No
Icons	Yes	Yes	No	No
Web URL	Yes	Yes	No	No

Design Principles

Great data visualization is not just about choosing the right chart — it is about creating a cohesive, accessible, and professional report experience.

Color Palette Consistency

Define a palette of 5-8 colors and use them consistently across all visuals.
Use your organization's brand colors as the starting point.
Apply a Power BI theme to enforce colors automatically.
Use sequential color gradients (light to dark) for ordered data.
Use distinct hues for categorical data.
Avoid red/green combinations alone — roughly 8% of men have red-green color blindness.

Choosing the Right Visual

Question You Want to Answer	Recommended Visual
How do categories compare?	Bar or column chart
How does a metric change over time?	Line chart
What is the part-to-whole breakdown?	Treemap, stacked bar, or (sparingly) pie chart
How are two measures related?	Scatter chart
Where are values located geographically?	Map
What is a single KPI value?	Card or KPI visual
What are the exact values?	Table or matrix
What drives a metric?	Key Influencers or Decomposition Tree
How does a value build to a total?	Waterfall chart
What is the conversion at each stage?	Funnel chart

Avoiding Chart Junk

"Chart junk" refers to unnecessary visual elements that do not convey data. Common offenders:

Chart Junk	Fix
3D effects	Always use 2D visuals
Unnecessary gridlines	Remove or lighten gridlines
Excessive colors	Limit to your defined palette
Decorative images	Remove unless they serve a clear purpose
Redundant labels	Show data labels OR an axis, not both
Busy backgrounds	Use plain white or light gray backgrounds
Too many visuals per page	Aim for 5-8 visuals per page maximum

Accessibility

Power BI reports should be usable by everyone, including people with visual impairments.

Accessibility Feature	How to Implement
Alt text	Select a visual > Format > General > Alt Text. Describe the visual's purpose and key insight.
Tab order	Use the Selection pane to set the order in which keyboard users tab through visuals.
High contrast	Test your report in high contrast mode (View > High contrast colors).
Color blind safe	Avoid relying on color alone to convey meaning — add labels, patterns, or icons.
Font size	Use a minimum of 12pt for body text and 16pt for titles.
Descriptive titles	Every visual should have a clear, descriptive title (not "Chart 1").
Keyboard navigation	Ensure all interactive elements (slicers, buttons) are reachable via keyboard.

Layout and Alignment

Use guides (View > Guides) to create a grid for consistent placement.
Snap to grid (View > Snap to grid) helps align visuals precisely.
Align and Distribute tools (Format > Align) space visuals evenly.
Group related visuals together and separate groups with whitespace.
Place the most important visuals in the top-left area (where the eye naturally starts in left-to-right reading cultures).
Use consistent visual sizes — avoid one tiny chart next to one enormous chart.

The Visual Design Checklist

Before publishing a report, review each visual against this checklist:

Item	Check
Does the visual have a clear, descriptive title?	Yes / No
Is the visual type appropriate for the data?	Yes / No
Are colors consistent with the report palette?	Yes / No
Are data labels legible and not overlapping?	Yes / No
Does the visual have alt text?	Yes / No
Is the visual properly aligned with neighbors?	Yes / No
Are axes labeled and appropriately scaled?	Yes / No
Does the visual respond correctly to slicer selections?	Yes / No
Is the visual free of chart junk?	Yes / No
Is the font size readable (12pt+ for body)?	Yes / No

Practice Exercises

Exercise 1: Sales Dashboard Visuals

Objective: Create a report page with multiple visual types using a sample sales dataset.

Steps:

Open Power BI Desktop and load the sample data (or use the built-in sample datasets).
Create the following visuals on a single page:
- A clustered column chart showing Sales by Product Category.
- A line chart showing Sales trend over months.
- A card displaying Total Revenue.
- A donut chart showing Sales distribution by Region.
- A table showing the top 10 products by revenue with conditional formatting (data bars on the Revenue column).
Add a slicer for Year.
Format all visuals with consistent colors using a theme.
Add descriptive titles to every visual.
Add alt text to at least two visuals.

Exercise 2: Geographic Analysis

Objective: Build a map-focused report page.

Steps:

Create a map visual (bubble map) showing Sales by City. Size bubbles by revenue.
Create a filled map showing Profit Margin by State/Province. Use a diverging color scale (red for negative, green for positive).
Add a matrix below the maps showing Region > State > City with Sales and Profit columns.
Apply conditional formatting to the matrix:
- Background color gradient on Sales.
- Icons on Profit (green arrow up for positive, red arrow down for negative).
Ensure the maps and matrix cross-filter each other.

Exercise 3: KPI Dashboard

Objective: Build an executive KPI dashboard.

Steps:

Create four card visuals across the top: Total Revenue, Total Profit, Customer Count, Average Order Value.
Create a KPI visual showing Monthly Revenue with a trend axis and target.
Create a gauge visual showing YTD Revenue against the annual target.
Create a waterfall chart showing Revenue buildup by Product Category.
Apply consistent formatting: use a custom theme, set uniform font sizes, add borders to all visuals.

Exercise 4: AI-Powered Analysis

Objective: Use AI visuals to discover insights.

Steps:

Create a Decomposition Tree analyzing Total Sales, with Explain By fields: Region, Category, Product, Sales Channel.
Use the AI option (High Value) to automatically drill into the highest-contributing path.
Create a Key Influencers visual analyzing what drives high-value orders (orders above $500). Add potential influencers: Product Category, Customer Segment, Region, Order Channel.
Review the Top Segments tab to find combinations of factors that predict high-value orders.

Exercise 5: Conditional Formatting Mastery

Objective: Apply every type of conditional formatting to a matrix.

Steps:

Create a matrix with Rows = Product Category > Product Name, Columns = Quarter, Values = Revenue and Profit Margin %.
Apply the following conditional formatting:
- Background color (gradient) on Revenue — light yellow to dark blue.
- Font color (rules) on Profit Margin — red if below 20%, yellow if 20-40%, green if above 40%.
- Data bars on Revenue.
- Icons on Profit Margin (use traffic light icons).
Toggle between different formatting options to see their effect.
Verify that the formatting updates when a slicer is changed.

Summary

In this chapter, you explored the full spectrum of Power BI visualizations:

Topic	Key Takeaway
Bar and Column Charts	The default choice for comparing categories; use clustered for comparison, stacked for composition
Line and Area Charts	Best for time-series trends; use combo charts for dual-axis scenarios
Pie and Donut Charts	Use sparingly and only with few categories; prefer treemaps for many segments
Scatter and Bubble Charts	Reveal relationships between two measures; use play axis for animated time analysis
Tables and Matrix	Show exact values; enhance with conditional formatting for rich data grids
Card and KPI	Display single values prominently; use KPI for trend + target in one visual
Gauge	Speedometer-style display for performance metrics; consider cards as a space-saving alternative
Maps	Bubble maps for point data, filled maps for regions; ensure clean geographic data
Treemap	Compact display of many categories with part-to-whole encoding
Waterfall	Bridge charts showing contributions to a total
Funnel	Sequential stage-based processes with declining values
Decomposition Tree	AI-powered interactive drill-down for root cause analysis
Key Influencers	AI visual identifying what drives a metric
Slicers	Interactive filter controls placed directly on the canvas
Custom Visuals	Extend Power BI with AppSource marketplace visuals
Conditional Formatting	Background color, font color, data bars, and icons for data-driven visual cues
Design Principles	Consistency, accessibility, appropriate visual selection, and minimal chart junk

Next chapter: We dive into Filters & Slicers — learning how to control what data users see through visual-level, page-level, and report-level filters, drillthrough, and interactive filtering techniques.