Themes and Color Formatting
Power BI themes help you maintain a consistent appearance across report pages. They define common colors, text styles, and visual formatting so that a report looks professional and communicates information clearly.
Learning Objectives
- Understand Power BI themes and their purpose.
- Apply built-in themes to reports.
- Customize report colors and visual appearance.
- Understand how themes differ from individual visual formatting.
- Use color consistently while maintaining readability.
- Practice applying a theme to a business report.
1. What Is a Power BI Theme?
A Power BI theme is a collection of formatting settings that helps standardize the appearance of report visuals. Instead of manually choosing colors for every chart, you can apply a theme to establish a consistent visual style.
How a Theme Affects a Report
Themes are particularly useful when a report contains several pages and many different visuals. They reduce repetitive formatting work and help maintain a recognizable design.
2. Benefits of Using Themes
Key Benefits
- Consistency: Similar visuals use a coordinated color palette.
- Efficiency: Apply common formatting without styling every visual individually.
- Brand identity: Use colors that match an organization's visual identity.
- Readability: Establish deliberate color and text combinations.
- Maintainability: Update the overall report appearance more easily.
3. Apply a Built-in Theme
Power BI Desktop includes built-in themes that can be applied to reports. They provide ready-made color combinations and formatting choices that can be customized when needed.
Steps to Apply a Theme
- Open your report in Power BI Desktop.
- Open the View tab on the ribbon.
- Locate the Themes section.
- Choose a built-in theme from the available options.
- Review the report pages and check how the visuals appear.
- Adjust individual visuals if the result needs refinement.
4. Customize Theme Colors
A customized theme can use a coordinated palette that matches your business or project. Choose colors that are easy to distinguish and avoid using too many unrelated shades.
Example Business Color Palette
Steps to Customize Theme Colors
- Open the View tab.
- Open the theme customization options, where available.
- Choose colors for data series and other supported theme settings.
- Apply the changes and inspect the report visuals.
- Confirm that text and chart elements remain readable.
The available customization controls can vary by Power BI Desktop version. You can also import a custom JSON theme when your workflow requires more control over theme settings.
5. Understand Theme Colors and Visual Colors
A report theme provides default styling, but a visual can also have its own formatting settings. For example, a chart may use a manually selected data color that differs from the theme's default palette.
| Formatting Level | Purpose | Example |
|---|---|---|
| Report theme | Defines shared formatting defaults. | A coordinated palette across report visuals. |
| Visual formatting | Controls appearance for a particular visual. | Changing the title color of one chart. |
| Data colors | Controls the colors used for data series or categories. | Using separate colors for product categories. |
| Conditional formatting | Applies formatting based on data values or rules. | Highlighting values below a sales target. |
6. Format Chart Data Colors
Data colors help users distinguish categories and compare values. Use a consistent approach so that the same category has the same meaning across report pages whenever possible.
Consistent Category Colors
Steps to Format Data Colors
- Select the chart on the report canvas.
- Open the Format visual pane.
- Locate the data color settings for the selected visual.
- Choose the appropriate colors for the series or categories.
- Check the legend and labels to ensure the meaning is clear.
7. Use Color to Communicate Meaning
Color can emphasize important information, but its meaning should remain consistent with the business context. Use color intentionally rather than decorating every visual with unrelated shades.
Example Business Color Rules
- Blue: General business metrics or primary data.
- Green: Favorable performance, when appropriate.
- Amber: A result that requires attention.
- Red: A significant issue or unfavorable result.
- Gray: Neutral information or supporting elements.
Define these rules for the report and apply them consistently. A color should not imply that a result is good or bad unless that interpretation is appropriate for the metric.
Color with Clear Status Labels
8. Import a Custom JSON Theme
Power BI supports importing theme definitions from JSON files. A custom JSON theme can define properties such as the report color palette and supported visual formatting defaults.
Example JSON Theme
{
"name": "CIIT Business Theme",
"dataColors": [
"#1E3A8A",
"#2563EB",
"#0891B2",
"#16A34A",
"#D97706",
"#7C3AED"
],
"background": "#FFFFFF",
"foreground": "#1F2937",
"tableAccent": "#2563EB"
}
Save the JSON content in a file such as
CIITBusinessTheme.json. Then open the theme import option
from the View tab in Power BI Desktop and select the file.
9. Common Theme and Color Mistakes
| Mistake | Why It Is a Problem | Better Approach |
|---|---|---|
| Using too many unrelated colors | Users struggle to identify patterns. | Choose a small, coordinated palette. |
| Using low-contrast text | Labels become difficult to read. | Use readable text and background combinations. |
| Changing category colors between pages | The same category may appear to mean something different. | Keep category colors consistent. |
| Relying only on red and green | Some users may not distinguish the colors easily. | Add text labels, values, or symbols. |
| Applying a theme without checking visuals | Existing formatting may not produce the intended result. | Review each report page after applying the theme. |
10. Practical Exercise
Scenario: Create a Consistent Business Report
You are creating a sales report for CIIT TRANING INSTITUTE. The report includes revenue, profit, student registrations, course categories, and monthly performance.
Tasks
- Open the report in Power BI Desktop.
- Apply a built-in theme and inspect the report pages.
- Create a coordinated palette using navy, blue, teal, and green.
- Apply consistent colors to the same categories across charts.
- Check titles, labels, and backgrounds for readability.
- Import the sample JSON theme or create your own theme file.
- Compare the report before and after theme customization.
- Confirm that color does not communicate important status by itself.
Expected Outcome
The report should have a consistent visual identity, readable charts, meaningful category colors, and a professional appearance across its pages.
11. Knowledge Check
Question 1: What is the main purpose of a Power BI theme?
A. To delete unused report pages
B. To apply consistent formatting defaults across a report
C. To change the underlying data source
Question 2: Where can you find themes in Power BI Desktop?
A. View tab
B. Data source credentials only
C. Windows Task Manager
Question 3: Why should the same category use consistent colors?
A. To help users recognize the category across visuals
B. To increase the number of colors
C. To hide chart labels
Question 4: What is a JSON theme useful for?
A. Defining supported theme properties and data colors
B. Replacing every data table
C. Creating relationships between database tables automatically
Question 5: What should you check after applying a theme?
A. Only the first chart
B. All relevant report pages and visual formatting
C. Only the report file name
Show Answers
- B — Themes establish consistent formatting defaults.
- A — Themes are available from the View tab.
- A — Consistent colors help users recognize categories.
- A — JSON can define supported theme settings and colors.
- B — Review the report to identify unexpected formatting.
Summary
Power BI themes provide a consistent visual foundation for reports. Built-in themes, custom colors, and JSON theme files can help establish a professional design while reducing repetitive work.
- Apply themes from the View tab in Power BI Desktop.
- Choose a coordinated color palette that fits the report's purpose.
- Keep category colors consistent across report pages.
- Understand the difference between theme defaults and visual-level formatting.
- Use readable text, sufficient contrast, and clear labels.
- Review visuals after changing or importing a theme.