Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI Format Visuals


Share

The Format Visual Pane

Every visual can be formatted: its title, colors, labels, axes and more.

Select a visual, and then select the Format visual icon (the paint brush) in the Visualizations pane.

The pane has two tabs:

TabWhat it formatsSections, for example
VisualThe parts of this type of visualX-axis, Y-axis, Columns, Data labels, Legend (for a column chart)
GeneralThings almost every visual hasProperties (size and position), Title, Effects (background, border, shadow), Header icons, Tooltips, Alt text

The sections on the Visual tab change with the visual type.

A pie chart has no X-axis, so it has no X-axis section.

There are many settings.

To find one fast, type its name, for example display units, in the search box at the top of the pane.

The Format visual pane in Power BI Desktop for a clustered column chart, with the Visual and General tabs, the search box, and the Visual tab sections X-axis, Y-axis, Columns and Data labels


The Example: Sales by Store

In this chapter you format a column chart of sales by store, step by step.

Work in your file from the DAX chapter, for example poke_mart_dax.pbix (see Power BI Visuals for what it holds).

The chart uses the measure Total Sales.

  1. Click an empty spot on the canvas and select Clustered column chart.
  2. Drag Store from the Stores table to the X-axis well, and Total Sales to the Y-axis well.
  3. The chart shows the stores from the highest to the lowest sales. If it does not, select More options (...) > Sort by > Total Sales, and then Sort by > Sort descending.

The chart has six columns:

StoreTotal Sales
Goldenrod City2,280,550
Cerulean City1,666,550
Slateport City1,598,550
Viridian City1,414,600
Lilycove City1,373,450
Violet City1,083,100

Power BI gives the chart the title Total Sales and an automatic subtitle, by Store.

It is correct, but it can be better.


Title

The title is on the General tab, because every visual has one.

  1. Select the chart, select Format visual, and select the General tab.
  2. Expand Title. Under Title, change Text to Sales by Store.
  3. Subtitle is already on. Under Subtitle, set its Text to All products, 2024 and 2025.

A good title says what the reader sees.

The subtitle says what is included, so nobody has to guess the period.

The same section has settings for the font, size, color and alignment of the title.


Data Labels

Data labels write the value on each column, so readers do not have to read it off the axis.

  1. On the Visual tab, turn on Data labels.
  2. Expand Data labels > Value. Set Display units to Thousands and Value decimal places to 0.

Each column now has a short label:

StoreTotal SalesData label
Goldenrod City2,280,5502,281K
Cerulean City1,666,5501,667K
Slateport City1,598,5501,599K
Viridian City1,414,6001,415K
Lilycove City1,373,4501,373K
Violet City1,083,1001,083K

The labels are rounded to the nearest thousand: 2,280,550 becomes 2,281K.



Display Units

Display units shorten big numbers.

They appear in many places, for example data labels and axes.

Cards shorten big numbers on their own, with no setting to change.

This is how Goldenrod City's 2,280,550 looks with each setting:

Display unitsDecimal placesShows
None02,280,550
Thousands02,281K
Millions22.28M
Millions02M

The last row shows the risk: with 0 decimal places in millions, 2,280,550 and 1,666,550 both round to 2M.

Choose a unit and decimal places that keep the differences visible.

Auto, the default in many visuals, lets Power BI pick a unit based on the size of the numbers.

Note: Display units change only how the number looks in this visual.

The measure itself, and every other visual that uses it, stays the same.


Axes

With data labels on the columns, the axes can be quieter:

  1. Expand X-axis. Its Title is off by default, and can stay off. The store names explain themselves.
  2. Expand Y-axis. Under Values, set Display units to Millions. The Y-axis Title is off by default too.

You can also turn off the whole Y-axis with the switch next to its name.

The data labels already show every value.


Colors

Use color to point at what matters. Here, the best store:

  1. On the Visual tab, expand Columns.
  2. In the Categories list, keep All, and set Color to a light gray.
  3. In the Categories list, select Goldenrod City, and set Color to a strong color, for example dark green. The theme colors have no green, so select More colors... and type 1E6B3C in the Hex box.
StoreData labelColumn color
Goldenrod City2,281KDark green
Cerulean City1,667KLight gray
Slateport City1,599KLight gray
Viridian City1,415KLight gray
Lilycove City1,373KLight gray
Violet City1,083KLight gray

Goldenrod City now stands out at once.

It sold 614,000 more than the next store, Cerulean City.

The formatted Power BI column chart titled Sales by Store with the subtitle All products, 2024 and 2025: Goldenrod City in dark green, the other five stores in light gray, data labels in thousands such as 2,281K, and no axis titles

This color is fixed to Goldenrod City.

To color columns by their value instead, for example red for a low margin, use conditional formatting.


Format Painter

When one visual looks right, you can copy its formatting to another visual, just like the Format Painter in Excel:

  1. Select the visual that has the formatting you want.
  2. On the Home tab, in the Clipboard group, select Format painter.
  3. Select the visual you want to format.

The format painter copies the formatting, not the data.

The second visual keeps its own fields.


Report Themes

A theme sets the colors, fonts and default formatting for the whole report at once.

  1. On the View tab, in the Themes section, select the dropdown arrow.
  2. Select one of the built-in themes. All visuals get the new colors and fonts.

In the same dropdown, Customize current theme lets you change the colors and fonts of the theme for this report.

A theme does not overwrite formatting you set by hand.

The gray and green columns in the example stay gray and green until you reset the visual.

When you pick a color, choose one of the theme colors at the top of the color list when you can, rather than More colors....

Theme colors change with the theme.

A color from More colors... stays fixed, like the green of Goldenrod City.


Reset to Default

Every section of the Format visual pane has a Reset to default link at the bottom.

It removes your changes in that section, and the visual goes back to the look of the theme.

Press Ctrl + Z to undo just your last change.


Tips for Consistent Reports

  • Start with a theme, instead of formatting each visual one by one.
  • Use the same number format for the same kind of number everywhere, for example all sales in thousands.
  • Use one strong color for what matters, and calm colors for the rest.
  • Give visuals of the same kind the same size, and line up their edges. The Format tab on the ribbon has commands to align visuals.
  • Write titles the same way on every visual, for example "Sales by Store", "Sales by Month".


Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.