Power BI Formatting and Styling Visuals

A report with correct data but poor formatting is difficult to read and easy to misunderstand. Formatting transforms a functional report into a professional, polished product that communicates clearly and builds trust with its audience. This topic covers how to format visuals, establish consistency, and make your reports look intentional rather than default.

Accessing Format Options

Click on any visual to select it. In the Visualizations pane on the right, you see three icons below the visual type icons. The paintbrush icon opens the Format pane. This is where all formatting options live for the selected visual.

The Format pane has two main sections:

• Visual: Formatting specific to the visual type — axis labels, data labels, bar colors, line thickness, and more.
• General: Formatting that applies to the visual's container — title, background, border, shadow, and position/size settings.

Titles — Make Every Visual Self-Explanatory

Every visual should have a title that tells the viewer exactly what the chart shows. A bar chart titled "Revenue" is vague. A chart titled "Revenue by Product Category — 2024" is immediately clear.

In the Format pane under General, find the Title section. Enable the title toggle if it is off. Type the title text. Adjust font size (14 to 16 is appropriate for chart titles), font color (dark grey on a white background is easier to read than pure black), and alignment (left-aligned titles feel modern; center-aligned suits symmetrical layouts).

Data Labels — Show the Numbers Directly

Data labels display the actual value on or near each bar, point, or slice in your visual. Viewers do not need to estimate values by looking at the axis — the number is written directly on the chart element.

In the Format pane under Visual, find Data Labels and toggle them on. Set the display units to match your data scale — "Millions" for large revenue figures, "Thousands" for smaller amounts. Set decimal places to a sensible number (usually 0 to 1 for rounded values, 2 for precise financial figures).

Avoid overcrowding charts with data labels. On a bar chart with 20 bars, labels overlap and become unreadable. Use data labels on charts with 10 or fewer items, or consider removing them and relying on tooltips instead.

Colors — Use Them with Purpose

Random colors make a chart look unprofessional. Purposeful color communicates meaning. Green for positive values, red for negative. Blue for one product category, orange for another — consistently applied across all charts in the report.

Setting Bar Colors

In the Format pane under Visual, find Bars (or Columns) and click the Colors section. You can set one color for all bars, or toggle on "Show All" to assign a different color to each category.

Conditional Formatting

Conditional formatting colors cells or bars automatically based on rules. Right-click a measure in a table visual's values area and select Conditional Formatting. Set rules like: color red if value is below target, green if above. The report then highlights underperforming or overperforming items automatically without manual updates.

Color Theme

Power BI applies a default color theme to all visuals. Change the theme for the entire report by going to the View tab and clicking Themes. Pre-built themes change all visual colors simultaneously. You can also create custom themes to match your company's brand colors.

Axes — Keep Them Clean and Clear

Axes that are cluttered or unclear make charts harder to read. Simplify them:

Axis Titles

Axis titles can often be removed if the chart title or data labels already make the content obvious. A bar chart titled "Revenue by Region" does not need an X-axis title saying "Revenue" — it repeats information the viewer already has. Toggle axis titles off in the Format pane when they add no new information.

Number Formatting on Axes

Set display units on axes to match the scale of your data. Revenue in crores should show as "1.5 Cr" not "15000000." Find the Y Axis or X Axis section in the Format pane and set Display Units to "Millions" or "Billions" as appropriate.

Gridlines

Light, subtle gridlines help viewers read values across a chart. Heavy, dark gridlines distract. In the Format pane, find Gridlines under the Y Axis section and set the color to a very light grey (10% to 20% opacity) rather than the default darker grey.

Visual Borders and Backgrounds

Adding a subtle border or background to visuals separates them from the report background and creates a card-like appearance. In the Format pane under General, find Background and toggle it on. Set a very light fill color — almost white, or a very pale shade of your theme color. This adds depth without distraction.

In the same General section, find Border and toggle it on. Set color to light grey and a rounded corner value of 4 to 8 pixels for a modern look.

Report Page Background

The default canvas background is white. A light grey page background (like #F5F5F5) makes white visual containers stand out visually and reduces eye strain on screen.

To change the page background, click on an empty area of the canvas to deselect all visuals. In the Visualizations pane, the Format section changes to show page-level options. Find Wallpaper or Canvas Background and set a color or image.

Alignment and Spacing

Misaligned visuals make a report look amateurish. Power BI has alignment tools to fix this quickly. Select multiple visuals by holding Shift and clicking each one. In the Format tab in the ribbon, use the Align options to align the selected visuals to the left edge, right edge, top edge, or center. Use Distribute options to space them evenly.

Enable gridlines (View tab → Show Gridlines) and snap to grid (View tab → Snap to Grid) to help position visuals consistently on the canvas.

Tooltips — Extra Information on Hover

Tooltips appear when a viewer hovers their mouse over a data point. By default, Power BI shows the basic values (category and measure). You can customize tooltips to show additional information without cluttering the visual itself.

In the Format pane under General, find Tooltips. Here you can add extra fields to the tooltip. You can also create an entire separate report page as a "tooltip page" — a small mini-report that appears on hover, showing a detailed breakdown of the data point being examined.