Applying Themes, Colors, Typography, and Consistent Formatting in Power BI

Course: Microsoft Power BI Training

Topic: Applying Themes, Colors, Typography, and Consistent Formatting

Course Link: Microsoft Power BI Training at JustAcademy

Demo Link: Register for a Course Demo

JustAcademy Website: Visit JustAcademy

1. Introduction to Themes, Colors, Typography, and Formatting

Power BI is a business intelligence platform used to transform data into interactive reports and dashboards. A successful report should not only display accurate information but also present that information clearly and consistently.

Themes, colors, typography, and formatting help report developers create professional-looking reports that are easy to understand, navigate, and maintain. These design choices influence how users identify important metrics, compare categories, interpret trends, and understand relationships between different visuals.

For example, a sales report may use a consistent blue color for revenue, green for positive performance, red for negative performance, and a standard font throughout the report. When these choices are applied consistently, users can understand the report more quickly.

Learning Objectives

• Understand Power BI themes and their purpose.
• Apply built-in themes and customize report colors.
• Understand color palettes and semantic color usage.
• Configure typography, font sizes, and text hierarchy.
• Format charts, cards, tables, slicers, and other visuals consistently.
• Use conditional formatting to communicate important information.
• Import and apply custom JSON theme files.
• Improve report readability, accessibility, and visual consistency.
• Develop a reusable formatting standard for Power BI reports.
• Troubleshoot common theme and formatting problems.

2. What Are Themes in Power BI?

A theme is a collection of visual design settings that establishes the appearance of a Power BI report. A theme can define default colors, text styles, visual backgrounds, borders, and other supported formatting properties.

Instead of manually configuring every visual from scratch, report developers can apply a theme to create a consistent starting point for the entire report.

2.1 Why Themes Are Important

• Consistency: Helps visuals follow a common design system.
• Brand identity: Allows reports to reflect company or organizational colors.
• Efficiency: Reduces repetitive formatting work.
• Readability: Establishes predictable visual styles and color relationships.
• Maintainability: Makes it easier to update the overall report appearance.
• Professional presentation: Helps reports look organized and polished.

2.2 Example of a Report Theme

Imagine a business report with the following design choices:

These values are examples. A real theme should be selected according to the organization's branding, report purpose, accessibility requirements, and the supported Power BI formatting properties.

3. Understanding Built-In Power BI Themes

Power BI Desktop provides built-in themes that offer predefined combinations of colors and formatting. These themes are useful when creating a report quickly or exploring different visual styles.

3.1 Applying a Built-In Theme

1. Open the report in Power BI Desktop.
2. Open the View tab on the ribbon.
3. Locate the Themes section.
4. Open the available theme gallery or theme menu.
5. Select a theme that suits the report's purpose.
6. Review the appearance of the report visuals.
7. Adjust individual visuals when necessary.
8. Save the report after verifying the changes.

The exact labels and layout of the theme controls may vary slightly by Power BI Desktop version.

3.2 Choosing an Appropriate Theme

Consider the following factors when choosing a theme:

• Business purpose: An executive report may require a restrained, formal design, while an exploratory report may use a broader palette.
• Audience: Ensure that the design is appropriate for the people who will read the report.
• Data complexity: Reports with many categories need distinguishable colors.
• Branding: Follow approved organizational colors and typography where applicable.
• Accessibility: Ensure that text and visual elements remain distinguishable.
• Consistency: Select a theme that can be applied across all report pages.

3.3 Built-In Themes vs. Custom Themes

4. Understanding Colors in Power BI

Color is an important part of report design. It can distinguish categories, emphasize key performance indicators, identify unusual values, and guide users through a report.

However, using too many colors or assigning colors inconsistently can make reports confusing. A carefully planned palette provides enough contrast to distinguish data without overwhelming the reader.

4.1 Types of Colors Used in Reports

• Primary colors: Main brand or report colors used for important visuals and headings.
• Secondary colors: Supporting colors used for additional categories or data series.
• Accent colors: Colors used to draw attention to selected information.
• Neutral colors: Whites, grays, and similar tones used for backgrounds, separators, and supporting text.
• Semantic colors: Colors with a consistent meaning, such as green for favorable results and red for unfavorable results.

4.2 Example Color Palette

These hex codes are illustrative and are not a mandatory Power BI palette. Check text contrast and the appearance of the complete report before adopting them.

4.3 Color Consistency Across Visuals

If a report uses blue to represent revenue in one chart, the same category should generally retain the same color in other related charts. Changing colors arbitrarily can cause users to misinterpret the data.

For example, if the product category Electronics is blue in a sales chart, it should remain blue in another related product comparison chart when both charts use the same category-color mapping.

4.4 Best Practices for Color Selection

• Use a limited, deliberate color palette.
• Reserve accent colors for important information.
• Use neutral backgrounds to keep attention on the data.
• Maintain consistent category colors across report pages.
• Avoid using similar colors for categories that must be distinguished easily.
• Use red and green carefully because not all users perceive them in the same way.
• Do not communicate meaning through color alone; use labels, symbols, or explanatory text as appropriate.
• Check contrast between text, data marks, and backgrounds.
• Consider how the report looks on different displays and when exported.

5. Applying and Customizing Visual Colors

Power BI allows developers to customize colors for individual visuals. Depending on the visual type, formatting options may include data colors, background colors, title colors, labels, borders, and other visual properties.

5.1 Changing a Chart's Data Colors

1. Select the chart you want to format.
2. Open the Format visual pane.
3. Find the section related to data colors or the visual's series formatting.
4. Choose the color for the required data series or category.
5. Repeat for additional series when necessary.
6. Verify that the colors are distinguishable and consistent with the report palette.

The exact name and location of the color controls can differ by visual type and Power BI version.

5.2 Changing a Visual Background

1. Select the visual.
2. Open Format visual.
3. Locate the background or effects settings, if supported.
4. Enable the background if required.
5. Choose an appropriate color.
6. Adjust transparency if the control is available.
7. Check that the background does not reduce the readability of labels or data marks.

5.3 Formatting Titles and Labels

Visual titles and data labels should use colors that contrast clearly with their backgrounds. Avoid choosing a light text color on a light background or a dark text color on a dark background.

For example, a dark blue chart title on a white background can create a clear visual hierarchy. Small data labels should remain readable without overpowering the chart.

6. Understanding Typography in Power BI

Typography refers to how text is presented, including font family, font size, font weight, alignment, line spacing where supported, and text color.

Good typography helps users distinguish report titles, section headings, chart titles, data labels, axis labels, and supporting notes. Poor typography can make even accurate reports difficult to read.

6.1 Main Typography Elements

6.2 Establishing a Typography Hierarchy

A typography hierarchy uses different text sizes and weights to show which information is most important.

These sizes are general design suggestions, not fixed Power BI requirements. Choose sizes based on the report canvas, audience, display resolution, and accessibility needs.

6.3 Choosing a Font Family

Use a font family that is readable and supported in the intended viewing environment. Simple sans-serif fonts are commonly used in business reports because they remain clear at different sizes.

Recommended practices include:

• Use one primary font family where practical.
• Use a second font only when there is a clear design reason.
• Avoid decorative fonts for dense analytical reports.
• Keep headings, labels, and body text visually consistent.
• Check whether fonts render correctly in Power BI Service and exported documents.
• Use readable sizes for labels and supporting text.

6.4 Formatting Text in Power BI Visuals

1. Select the visual to format.
2. Open Format visual.
3. Locate the title, labels, values, legend, or axis section.
4. Set the font family and size where available.
5. Choose font weight and text color where supported.
6. Set alignment and wrapping options where available.
7. Review the visual at the intended report viewing size.

Different visuals expose different formatting controls. A card, chart, table, and slicer may have different sections and options.

7. Consistent Formatting Across Report Pages

Consistent formatting means applying a common set of design rules across the entire report. This includes colors, fonts, titles, backgrounds, borders, spacing, number formats, and visual alignment.

Consistency makes a report easier to learn because users do not need to interpret a different design language on every page.

7.1 Common Formatting Elements

• Report titles and section headings.
• Visual titles and subtitles.
• Color palettes and category colors.
• Font families and text sizes.
• Page backgrounds and visual backgrounds.
• Border and outline styles.
• Data labels and axis formatting.
• Number formats, decimal places, and units.
• Visual spacing, alignment, and sizing.
• Headers, footers, legends, and explanatory notes.

7.2 Create a Formatting Standard

Before formatting a large report, define a simple design standard that specifies how the most important elements should appear.

7.3 Use Consistent Number Formatting

Number formatting is part of report consistency. If one visual displays sales as ₹1,250,000 and another displays the same amount as 1.25M without explanation, users may find it difficult to compare values.

Choose suitable formats for:

• Currency values.
• Percentages and ratios.
• Whole numbers and counts.
• Dates and times.
• Large numbers using thousands or millions where appropriate.

Use the same unit conventions throughout related visuals. If abbreviated units are used, make the meaning clear in titles or labels.

8. Using the Power BI Theme JSON File

Power BI supports custom themes defined in JSON files. A JSON theme can specify supported properties such as the report color palette and visual styling defaults.

Custom theme files are especially useful when an organization needs to apply a standard design across multiple reports.

8.1 Benefits of JSON Themes

• Reusable design settings.
• Consistent color palettes across reports.
• Reduced manual formatting for supported properties.
• Improved alignment with brand guidelines.
• Easier sharing of design standards among report developers.

8.2 Example of a Basic Custom Theme

{
  "name": "Business Analytics Theme",
  "dataColors": [
    "#1F4E79",
    "#2A9D8F",
    "#F4A261",
    "#7B61A8",
    "#E76F51",
    "#6B7280"
  ],
  "background": "#FFFFFF",
  "foreground": "#1F2937",
  "tableAccent": "#1F4E79"
}

This is a simple illustrative theme file. Theme properties and supported values can vary with the Power BI theme schema and application version. Validate the JSON against Microsoft's current theme documentation and test it in Power BI Desktop before using it in a production report.

8.3 Understanding the Example Properties

8.4 Importing a Custom Theme

1. Create a JSON file in a text editor.
2. Enter the theme name and supported formatting properties.
3. Save the file with a .json extension.
4. Open Power BI Desktop.
5. Go to the View tab and open the Themes menu.
6. Choose the option to browse for or import a theme, as available in your version.
7. Select the JSON file.
8. Review the report and confirm that the theme has been applied as expected.
9. Correct any unsupported properties or adjust individual visuals where needed.

8.5 Updating a Theme

If the organization changes its brand colors or typography standards, update the theme file and reapply the theme where necessary. Review important visuals afterward because a theme change may alter the appearance of charts and other supported elements.

9. Formatting Charts Consistently

Charts should use consistent colors, titles, axis styles, labels, and legends. The formatting should support the analytical purpose of the chart rather than distract from it.

9.1 Column and Bar Charts

• Use a consistent color for the same category across related charts.
• Choose clear axis labels and descriptive titles.
• Display data labels when they improve understanding.
• Avoid unnecessary gridlines and decorative effects.
• Ensure that categories are ordered logically.
• Use consistent number formats for values.

9.2 Line Charts

• Use distinguishable colors for different series.
• Keep date and time axes easy to read.
• Use markers when they help users identify individual observations.
• Avoid excessive line thickness or unnecessary visual effects.
• Keep legends clear when multiple series are displayed.
• Use a consistent date granularity when comparing related trends.

9.3 Pie and Donut Charts

• Use a limited number of categories.
• Choose clearly distinguishable segment colors.
• Use labels or tooltips to communicate values and percentages.
• Avoid similar colors for adjacent segments when possible.
• Consider a bar chart when accurate comparisons between many categories are important.

9.4 Chart Formatting Example

10. Formatting Cards and KPI Visuals

Cards and KPI visuals highlight important metrics such as total revenue, profit, customer count, order volume, and target achievement.

10.1 Card Formatting Guidelines

• Use a large, readable font for the main value.
• Use a concise title that identifies the metric.
• Keep currency symbols, units, and decimal places consistent.
• Use accent colors selectively.
• Ensure that the background and value have sufficient contrast.
• Align cards consistently when multiple KPIs appear together.

10.2 Example KPI Measures

Total Sales = SUM(Sales[SalesAmount])

Total Profit = SUM(Sales[Profit])

Total Orders = DISTINCTCOUNT(Sales[OrderID])

Profit Margin =
DIVIDE(
    [Total Profit],
    [Total Sales],
    0
)

These measures are examples. Update the table and column names to match your model. Use appropriate data types and format each measure according to its meaning.

10.3 Recommended Number Formats

The examples use Indian currency formatting. Choose the currency and number format appropriate for the report audience and business requirements.

11. Formatting Tables and Matrices

Tables and matrices display detailed records and grouped summaries. Consistent formatting helps users scan rows, compare values, and identify important information.

11.1 Table Formatting Guidelines

• Use clear column headers.
• Apply consistent font sizes to headers and data cells.
• Use appropriate alignment for text, dates, and numbers.
• Format currency and percentage columns consistently.
• Use subtle row banding when it improves readability.
• Avoid excessive borders and unnecessary background colors.
• Use conditional formatting to emphasize important values when appropriate.
• Ensure that column widths allow key values and labels to be read.

11.2 Matrix Formatting Guidelines

• Use meaningful row and column hierarchies.
• Format subtotals and grand totals distinctly.
• Keep number formats consistent across comparable values.
• Use indentation and spacing to clarify hierarchical levels where supported.
• Avoid displaying unnecessary totals that may confuse interpretation.

12. Conditional Formatting in Power BI

Conditional formatting changes the appearance of values according to rules, thresholds, or measure results. It is useful for identifying performance differences and drawing attention to exceptions.

12.1 Common Conditional Formatting Types

• Background color: Applies a background color based on a value or rule.
• Font color: Changes text color according to a condition.
• Data bars: Displays bars inside cells to represent relative values where supported.
• Icons: Uses symbols to indicate status or performance where supported.
• Color scales: Uses a gradient to represent differences in values where supported.

12.2 Example: Conditional Formatting for Profit

Suppose a table displays profit for different products. You can use a rule-based color scheme to distinguish positive and negative values.

These thresholds are examples. Select values based on business targets, expected ranges, and the meaning of the metric.

12.3 Applying Conditional Formatting

1. Select the table or matrix visual.
2. Locate the field or measure that needs conditional formatting.
3. Open the field's menu or the relevant formatting section.
4. Choose the supported conditional formatting option, such as background color, font color, data bars, or icons.
5. Choose a rule-based, gradient-based, or field-value method as appropriate.
6. Define the thresholds or select the field or measure that determines the formatting.
7. Apply the formatting.
8. Test the result with different values and filter selections.

Conditional formatting options vary by visual type and field. Always verify that the selected method is supported for the chosen visual.

13. Formatting Slicers and Filters

Slicers and filter controls allow report users to explore specific subsets of data. They should be visually consistent with the report while remaining easy to identify and operate.

13.1 Slicer Formatting Guidelines

• Use clear field labels such as Year, Region, or Product Category.
• Keep slicer titles and text sizes consistent.
• Use a background that separates the slicer from the report canvas without overpowering it.
• Arrange related slicers together.
• Keep selection states visually distinguishable.
• Avoid placing too many slicers in a small area.
• Use dropdown slicers for long lists when appropriate.

13.2 Filter Pane Consistency

Use meaningful field names and sensible default filters. Check that report-, page-, and visual-level filters do not contradict the report's titles or explanations.

For example, if a report title says “Annual Sales Overview,” verify whether the page is actually showing the intended year or years. Clear labeling and consistent filtering help prevent incorrect interpretations.

14. Backgrounds, Borders, Spacing, and Alignment

Colors and fonts are only part of report formatting. Visual arrangement also influences how users understand a report.

14.1 Backgrounds

• Use neutral backgrounds for most analytical report pages.
• Use strong colors sparingly for emphasis.
• Ensure that text and visual elements contrast with the background.
• Avoid unnecessary background images or decorative patterns.

14.2 Borders and Outlines

• Use borders when they help separate visual groups.
• Keep border colors and thicknesses consistent.
• Avoid outlining every visual if the layout is already clear.
• Use subtle separators for supporting information.

14.3 Spacing and Alignment

• Align related visuals along consistent edges.
• Use similar gaps between cards and charts.
• Keep titles and related content visually grouped.
• Avoid overlapping visuals or crowded labels.
• Use consistent margins and spacing within the report canvas as part of the design layout, not as additional HTML styling.

14.4 Example Page Layout

15. Using Themes with Existing Visual Formatting

Applying a theme does not guarantee that every existing visual will look exactly as expected. Visuals may have individually customized formatting, and theme changes can interact with those settings.

15.1 What to Check After Applying a Theme

• Verify that chart colors remain distinguishable.
• Check whether custom data colors are still appropriate.
• Review titles, legends, axes, and data labels.
• Inspect cards, tables, matrices, and slicers.
• Check backgrounds, borders, and visual effects.
• Confirm that conditional formatting still communicates the intended meaning.
• Look for text that becomes difficult to read after color changes.

15.2 Theme Changes and Manual Overrides

Individual visual settings can override theme defaults. As a result, a theme change may update some visuals while leaving others with custom colors or styles.

When the report must follow a strict design standard, review individual formatting settings after applying a theme. Update manual overrides when they conflict with the new design system.

16. Creating a Reusable Formatting Workflow

A repeatable workflow helps developers produce consistent reports and reduces the amount of time spent correcting visual differences.

16.1 Recommended Workflow

1. Understand the audience: Identify who will use the report and what decisions it must support.
2. Define the visual style: Select the theme, color palette, typography, and background style.
3. Prepare the data model: Confirm that fields and measures are ready for use in visuals.
4. Create core visuals: Build charts, cards, tables, and slicers using appropriate visual types.
5. Apply the theme: Set a consistent default appearance.
6. Format individual visuals: Adjust colors, titles, labels, axes, and other supported properties.
7. Standardize number formats: Align currency, percentage, date, and unit conventions.
8. Arrange the layout: Align visuals and maintain consistent spacing.
9. Check accessibility: Review contrast, text size, and non-color indicators.
10. Test interactions: Verify that filters and selections do not make labels or comparisons misleading.
11. Review every page: Compare the report against the formatting standard.
12. Save and publish: Verify the appearance in the intended viewing environment.

17. Common Formatting Mistakes

17.1 Using Too Many Colors

Problem: The report becomes visually noisy and users struggle to identify meaningful patterns.

Solution: Use a limited palette and reserve accent colors for important information.

17.2 Inconsistent Category Colors

Problem: The same category appears in different colors across related visuals, making comparison difficult.

Solution: Establish a consistent category-color mapping and review all related visuals.

17.3 Small or Unreadable Text

Problem: Users cannot easily read titles, labels, legends, or supporting notes.

Solution: Increase font sizes where necessary, reduce unnecessary labels, and allow enough space for text.

17.4 Excessive Bold Text

Problem: If everything is emphasized, nothing stands out.

Solution: Reserve bold styling for headings, key values, and important labels.

17.5 Poor Color Contrast

Problem: Text and data marks blend into their backgrounds.

Solution: Use contrasting foreground and background colors and test the report at realistic viewing sizes.

17.6 Overformatted Visuals

Problem: Excessive borders, shadows, gridlines, and decorative effects compete with the data.

Solution: Remove elements that do not improve understanding.

17.7 Inconsistent Number Formats

Problem: Users find it difficult to compare figures when units and decimal places change without explanation.

Solution: Standardize units, currency, percentages, and decimal precision.

17.8 Assuming a Theme Updates Every Setting

Problem: Some visuals retain manually configured formatting after a theme is applied.

Solution: Review custom overrides and update them when necessary.

18. Accessibility and Readability in Power BI

Accessible report design helps more users interpret the report, including people with color-vision deficiencies or reduced vision.

18.1 Accessibility Best Practices

• Use sufficient contrast between text and backgrounds.
• Avoid using color as the only indicator of status or meaning.
• Use clear titles and descriptive labels.
• Provide legends or explanatory text when colors represent categories.
• Choose font sizes that remain readable at the intended display scale.
• Use meaningful visual titles and alt text where supported.
• Check keyboard navigation and other accessibility features relevant to the report.
• Test the report in the environment where users will access it.

18.2 Example of Accessible Status Formatting

Instead of communicating performance using only green and red colors, include labels or icons such as “Above Target,” “Below Target,” or “On Track.” This allows users to understand the status even if they cannot distinguish the colors.

19. Practical Project: Design a Consistent Sales Report

In this practical project, you will apply a theme, create a consistent color palette, standardize typography, and format a complete sales report.

19.1 Required Fields

19.2 Create Measures

Total Sales = SUM(Sales[SalesAmount])

Total Profit = SUM(Sales[Profit])

Total Orders = DISTINCTCOUNT(Sales[OrderID])

Profit Margin =
DIVIDE(
    [Total Profit],
    [Total Sales],
    0
)

19.3 Build the Report

1. Create cards for Total Sales, Total Profit, Total Orders, and Profit Margin.
2. Create a column chart for sales by region.
3. Create a bar chart for sales by product.
4. Create a line chart for sales over time.
5. Create a table for product-level sales and profit.
6. Add slicers for year and region.

19.4 Apply the Design System

1. Select a built-in theme or import a custom theme.
2. Use the primary color for the main sales series.
3. Apply secondary colors to supporting series.
4. Use consistent titles and font sizes.
5. Format currency and percentage measures appropriately.
6. Use consistent background and border settings.
7. Align cards and charts into a logical layout.
8. Apply conditional formatting to profit values if useful.
9. Check readability and contrast across all visuals.
10. Test the report in Power BI Desktop and, where applicable, Power BI Service.

19.5 Expected Outcome

The final report should have a recognizable visual style, consistent category colors, readable typography, standardized number formats, and a layout that supports quick interpretation of sales performance.

20. Practice Exercises

Exercise 1: Apply a Built-In Theme

Create a report with at least three visuals. Apply a built-in theme and record the changes to the visual colors and formatting.

Exercise 2: Create a Custom Color Palette

Choose a primary color, two supporting colors, an accent color, and neutral background colors. Apply them consistently across charts, cards, and tables.

Exercise 3: Standardize Typography

Define styles for the report title, section headings, chart titles, KPI values, and data labels. Apply the styles to all report pages.

Exercise 4: Import a JSON Theme

Create a simple JSON theme with a name and data color palette. Import it into Power BI Desktop and verify the result.

Exercise 5: Apply Conditional Formatting

Create a profit table and configure conditional formatting to distinguish positive and negative results. Add labels or another visual cue so meaning is not conveyed through color alone.

Exercise 6: Review Accessibility

Inspect the report for small text, poor contrast, confusing colors, and unclear labels. Correct the issues and document the improvements.

Exercise 7: Build a Formatting Checklist

Create a checklist for theme, color, typography, number formats, backgrounds, spacing, and accessibility. Use it to review every page before publishing.

21. Interview Questions and Answers

Q1. What is a theme in Power BI?

A theme is a collection of supported design settings that establishes a consistent appearance for report visuals, including color palettes and other formatting defaults.

Q2. Why are themes useful?

Themes reduce repetitive formatting work, improve consistency, and help reports follow organizational branding guidelines.

Q3. What is the difference between a built-in theme and a custom theme?

A built-in theme is supplied by Power BI, while a custom theme can be created or imported to meet specific design requirements.

Q4. What is a JSON theme?

A JSON theme is a structured text file that defines supported theme properties, such as the report name and data color palette.

Q5. How do you apply a theme in Power BI Desktop?

Open the View tab, locate the Themes menu, and select a built-in theme or use the available option to import a custom theme.

Q6. What is the purpose of a color palette?

A color palette provides a planned set of colors that can be reused consistently across report visuals.

Q7. Why is consistent color usage important?

Consistent colors help users recognize categories and compare results without having to relearn the visual meaning in each chart.

Q8. What is typography in report design?

Typography includes font family, size, weight, alignment, and text color. It helps establish hierarchy and readability.

Q9. What is a typography hierarchy?

A typography hierarchy uses differences in size and weight to distinguish report titles, headings, visual titles, key values, and supporting information.

Q10. What is conditional formatting?

Conditional formatting changes the appearance of data based on values, rules, thresholds, or a field or measure.

Q11. Why should colors not be the only way to communicate meaning?

Some users cannot distinguish certain colors easily. Labels, icons, and explanatory text provide additional ways to understand the information.

Q12. Why might a visual not change after a theme is applied?

The visual may contain manually configured formatting that overrides theme defaults, or the theme may not define the property in question.

Q13. How can you improve table readability?

Use clear headers, consistent text sizes, appropriate alignment, standardized number formats, sensible column widths, and restrained conditional formatting.

Q14. What is the role of number formatting?

Number formatting makes values easier to interpret by displaying appropriate currency symbols, decimal places, percentages, dates, and units.

Q15. What should you check before publishing a Power BI report?

Review theme consistency, colors, typography, number formats, spacing, accessibility, interactions, and rendering in the intended viewing environment.

22. Quick Revision Checklist

• Understand what Power BI themes control.
• Know how to apply a built-in theme.
• Understand when to use a custom JSON theme.
• Use a limited and consistent color palette.
• Assign consistent colors to related categories.
• Use accent colors only when they support the analysis.
• Establish a clear typography hierarchy.
• Keep titles and labels readable.
• Standardize currency, percentages, dates, and units.
• Format charts, cards, tables, matrices, and slicers consistently.
• Use conditional formatting with meaningful rules.
• Maintain suitable contrast and accessibility.
• Review custom formatting overrides after applying a theme.
• Keep spacing, borders, and backgrounds consistent.
• Test the report before publishing.

23. Conclusion

Applying themes, colors, typography, and consistent formatting is an important part of professional Power BI report development. Themes provide a reusable design foundation, colors help distinguish categories and highlight important information, typography creates a clear hierarchy, and consistent formatting improves readability across report pages.

For effective results, choose a limited palette, use readable fonts, standardize number formats, apply conditional formatting carefully, and check accessibility. Custom JSON themes can help organizations reuse their design standards across multiple reports, while individual visual formatting allows developers to fine-tune specific elements.

A well-designed Power BI report combines accurate data with a clear, consistent, and accessible visual presentation. These practices help users understand the information and make more informed business decisions.

24. Additional Learning Resources

• Microsoft Power BI Training at JustAcademy
• Register for a JustAcademy Course Demo
• Visit JustAcademy
• Microsoft Learn: Use Report Themes in Power BI Desktop
• Microsoft Learn: Conditional Formatting in Power BI Tables and Matrices
• Microsoft Learn: Create and Format Power BI Reports