Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

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

Report Theme Primary Color Secondary Color Accent Color Text and Background Formatting Sales Performance Report Revenue $250K Profit $45K Orders 1,420 Consistent visual styling

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

  1. Open your report in Power BI Desktop.
  2. Open the View tab on the ribbon.
  3. Locate the Themes section.
  4. Choose a built-in theme from the available options.
  5. Review the report pages and check how the visuals appear.
  6. Adjust individual visuals if the result needs refinement.
Tip: Review all report pages after applying a theme. A color palette that works well for one chart may not be suitable for every visual or data category.

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

Navy Blue Teal Green Neutral #1E3A8A #2563EB #0891B2 #16A34A #E2E8F0 Use a small, coordinated set of colors throughout the report.

Steps to Customize Theme Colors

  1. Open the View tab.
  2. Open the theme customization options, where available.
  3. Choose colors for data series and other supported theme settings.
  4. Apply the changes and inspect the report visuals.
  5. 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.
Important: Applying a new theme does not guarantee that every manually formatted visual will change exactly as expected. Review individual visuals after changing the theme.

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

Revenue by Region Orders by Region North South East West North South East West The same region uses the same color in both charts.

Steps to Format Data Colors

  1. Select the chart on the report canvas.
  2. Open the Format visual pane.
  3. Locate the data color settings for the selected visual.
  4. Choose the appropriate colors for the series or categories.
  5. 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

On Track Target achieved or exceeded ! Needs Review Check performance against the target Below Target Review the performance gap

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.

Tip: This is a basic theme example. JSON theme support includes specific property names and structures. Validate your file if you add more settings, and inspect the report after importing it.

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

  1. Open the report in Power BI Desktop.
  2. Apply a built-in theme and inspect the report pages.
  3. Create a coordinated palette using navy, blue, teal, and green.
  4. Apply consistent colors to the same categories across charts.
  5. Check titles, labels, and backgrounds for readability.
  6. Import the sample JSON theme or create your own theme file.
  7. Compare the report before and after theme customization.
  8. 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
  1. B — Themes establish consistent formatting defaults.
  2. A — Themes are available from the View tab.
  3. A — Consistent colors help users recognize categories.
  4. A — JSON can define supported theme settings and colors.
  5. 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.