Color themes in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a color theme in Power BI?

A color theme is a set of colors used consistently across a Power BI report to make visuals look coordinated and easy to understand.

beginner

Why should you use color themes in your Power BI reports?

Using color themes helps keep reports visually consistent, improves readability, and supports brand identity or user preferences.

intermediate

How can you apply a custom color theme in Power BI?

You can apply a custom color theme by importing a JSON file that defines your chosen colors into Power BI's 'Switch theme' option.

intermediate

What is the format used to define custom color themes in Power BI?

Custom color themes are defined using a JSON file that lists colors with hex codes and names to be used in the report visuals.

beginner

Name one accessibility consideration when choosing colors for Power BI themes.

Ensure sufficient contrast between text and background colors so that all users, including those with vision impairments, can read the report easily.

What is the main purpose of using a color theme in Power BI?

A To increase report file size

B To add animations to charts

C To make visuals look consistent and clear

D To change data values automatically

Color themes help keep visuals consistent and easy to understand.

Which file format is used to import custom color themes in Power BI?

A .json

B .xml

C .csv

D .txt

Power BI uses JSON files to define and import custom color themes.

What should you check to make your color theme accessible?

A Use only grayscale colors

B Use only bright colors

C Use as many colors as possible

D Use colors with high contrast

High contrast colors help users with vision difficulties read the report easily.

Where do you find the option to change or import a color theme in Power BI?

A In 'Switch theme' menu

B Under 'Data' tab

C In 'Transform data' window

D In 'Visualizations' pane

The 'Switch theme' menu allows you to select or import color themes.

What happens if you don’t use a consistent color theme in your report?

A Report loads faster

B Visuals may look confusing or unprofessional

C Data refreshes automatically

D Report becomes interactive

Inconsistent colors can confuse users and reduce report clarity.

Explain how to create and apply a custom color theme in Power BI.

Think about the steps from defining colors to seeing them in your report.

Describe why color contrast is important in Power BI color themes and how it affects report accessibility.

Consider users who might have difficulty distinguishing colors.

Practice

1. What is the main purpose of using color themes in Power BI reports?

easy

A. To add animations to visuals

B. To create new data tables automatically

C. To keep report colors consistent and professional

D. To change the report layout structure

Solution

1. Step 1: Understand the role of color themes

   Color themes define a set of colors used consistently across a report.

2. Step 2: Identify the main benefit

   Using color themes ensures visuals look professional and consistent.

3. Final Answer:

   To keep report colors consistent and professional -> Option C

4. Quick Check:

   Color themes = Consistent colors [OK]

Hint: Color themes unify colors across visuals [OK]

Common Mistakes:

• Confusing color themes with animations
• Thinking color themes create data
• Assuming color themes change layout

2. Which file format is used to define a custom color theme in Power BI?

easy

A. .json

B. .xlsx

C. .csv

D. .xml

Solution

1. Step 1: Recall the file format for themes

   Power BI uses JSON files to define color themes with hex codes.

2. Step 2: Match the correct file extension

   JSON files have the extension .json.

3. Final Answer:

   .json -> Option A

4. Quick Check:

   Color themes = JSON files [OK]

Hint: Themes use JSON files with hex colors [OK]

Common Mistakes:

• Choosing XML instead of JSON
• Confusing CSV or Excel files for themes
• Not knowing file extensions

3. Given a Power BI report with a custom color theme applied, what happens when you change the theme JSON file and reapply it?

medium

A. The report layout resets to default

B. Only the background color changes, other colors stay the same

C. The data model refreshes automatically

D. All visuals update their colors according to the new theme

Solution

1. Step 1: Understand theme application effect

   Applying a theme updates all visuals' colors based on the theme's color definitions.

2. Step 2: Identify what changes on reapplying theme

   Changing the JSON and reapplying updates all colors, not just background.

3. Final Answer:

   All visuals update their colors according to the new theme -> Option D

4. Quick Check:

   Reapplying theme = Update all colors [OK]

Hint: Reapplying theme updates all visual colors [OK]

Common Mistakes:

• Thinking only background changes
• Assuming data refresh happens
• Believing layout resets

4. You tried to apply a custom color theme JSON file but Power BI shows an error. What is the most likely cause?

medium

A. The report has too many visuals

B. The JSON file has invalid syntax or missing commas

C. The data source is offline

D. The theme file is saved as .csv instead of .json

Solution

1. Step 1: Identify common JSON errors

   Invalid JSON syntax like missing commas or brackets causes errors when applying themes.

2. Step 2: Exclude unrelated causes

   Number of visuals or data source status does not affect theme application; file extension matters but is less common error than syntax.

3. Final Answer:

   The JSON file has invalid syntax or missing commas -> Option B

4. Quick Check:

   JSON syntax errors cause theme load failure [OK]

Hint: Check JSON syntax carefully for commas and brackets [OK]

Common Mistakes:

• Blaming data source or visuals count
• Ignoring JSON syntax errors
• Using wrong file extension

5. You want to create a color theme JSON file that defines three colors: primary (#1A73E8), secondary (#E37400), and background (#F5F5F5). Which JSON snippet correctly defines these colors for Power BI?

hard

A. {
"name": "CustomTheme",
"dataColors": ["#1A73E8", "#E37400"],
"background": "#F5F5F5",
"visualStyles": {}
}

B. {
"themeName": "CustomTheme",
"colors": {"primary": "#1A73E8", "secondary": "#E37400", "background": "#F5F5F5"}
}

C. {
"name": "CustomTheme",
"dataColors": ["#1A73E8", "#E37400"]
"background": "#F5F5F5"
}

D. {
"name": "CustomTheme",
"dataColors": ["#1A73E8", "#E37400"],
"backgroundColor": "#F5F5F5"
}

Solution

1. Step 1: Check required keys for Power BI theme

   Power BI themes use name, dataColors for main colors, and background for background color.

2. Step 2: Validate JSON keys and structure

   { "name": "CustomTheme", "dataColors": ["#1A73E8", "#E37400"], "background": "#F5F5F5", "visualStyles": {} } correctly uses name, dataColors array, and background key. It also includes visualStyles which is optional but valid.

3. Final Answer:

   { "name": "CustomTheme", "dataColors": ["#1A73E8", "#E37400"], "background": "#F5F5F5", "visualStyles": {} } -> Option A

4. Quick Check:

   Correct keys and hex colors = { "name": "CustomTheme", "dataColors": ["#1A73E8", "#E37400"], "background": "#F5F5F5", "visualStyles": {} } [OK]

Hint: Use 'name', 'dataColors', and 'background' keys in JSON [OK]

Common Mistakes:

• Using wrong key names like 'colors' or 'backgroundColor'
• Missing required keys like 'dataColors'
• Incorrect JSON structure or missing commas