Visual formatting options in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a clear and easy-to-read sales report that highlights monthly sales performance and trends using colors and formatting.

📊 Data: You have monthly sales data by product category and region for the last year.

🎯 Deliverable: Create a Power BI report with a bar chart showing monthly sales by category, formatted with colors to highlight high and low sales, and a table with conditional formatting to show sales performance.

Sample Data

Month	Category	Region	Sales
Jan	Electronics	North	12000
Jan	Clothing	North	8000
Feb	Electronics	South	15000
Feb	Clothing	South	7000
Mar	Electronics	East	13000
Mar	Clothing	East	9000
Apr	Electronics	West	14000
Apr	Clothing	West	8500
May	Electronics	North	16000
May	Clothing	North	9500
Jun	Electronics	South	17000
Jun	Clothing	South	8000

1

Step 1: Load the sample data into Power BI Desktop by importing the table.

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the data.

Expected Result

Data table with columns Month, Category, Region, Sales is loaded into Power BI.

2

Step 2: Create a bar chart visual showing total sales by Month and Category.

Drag 'Month' to Axis, 'Category' to Legend, and 'Sales' to Values (aggregated as SUM).

Expected Result

Bar chart displays monthly sales for each category with different colors for categories.

3

Step 3: Apply data colors to the bar chart to differentiate categories clearly.

In the Format pane, under 'Data colors', assign distinct colors to each category (e.g., Electronics = blue, Clothing = green).

Expected Result

Bar chart bars are colored distinctly by category for easy identification.

4

Step 4: Add conditional formatting to the sales column in a table visual to highlight high and low sales.

Create a table visual with Month, Category, Region, and Sales. In Format pane, under 'Conditional formatting' > 'Background color', set rules: sales above 15000 = green, below 9000 = red, others = yellow.

Expected Result

Sales cells in the table are colored green for high sales, red for low sales, and yellow for medium sales.

5

Step 5: Format the report title and axis labels for readability.

In Format pane, set title font size to 18, bold, and center aligned. Set axis labels font size to 12 and color to dark gray.

Expected Result

Report title and axis labels are clear and easy to read.

6

Step 6: Add data labels to the bar chart to show exact sales values on each bar.

In Format pane, enable 'Data labels' and set font size to 10.

Expected Result

Each bar shows the sales number on top for quick value reference.

Final Result

Yellow 12,000

↓

Red 8,000

↓

Green 15,000

↓

Red 7,000

✓Electronics consistently have higher sales than Clothing across months.

✓Sales peak in May and June for Electronics.

✓Conditional formatting quickly highlights months and categories with low sales needing attention.

Bonus Challenge

Add a slicer to the report to filter sales by Region and observe how the visuals update dynamically.

Show Hint

Use the 'Slicer' visual, drag the 'Region' field into it, and test selecting different regions.

Practice

1. What is the main purpose of using visual formatting options in Power BI reports?

easy

A. To create new calculated columns

B. To add more data to the report

C. To change the data source

D. To make reports clearer and easier to understand

Solution

1. Step 1: Understand the role of visual formatting

   Visual formatting changes how the report looks, such as colors and fonts, to improve clarity.

2. Step 2: Identify the main goal of formatting

   The goal is to help users understand data quickly by making visuals clear and attractive.

3. Final Answer:

   To make reports clearer and easier to understand -> Option D

4. Quick Check:

   Formatting improves clarity = D [OK]

Hint: Formatting improves clarity, not data content [OK]

Common Mistakes:

• Confusing formatting with data changes
• Thinking formatting adds data
• Mixing formatting with data modeling

2. Which of the following is the correct way to change the background color of a visual in Power BI?

easy

A. Use the Format pane and select Background color option

B. Use the Data pane to select background color

C. Right-click the visual and choose Change Data Source

D. Edit the report theme JSON file manually

Solution

1. Step 1: Locate the Format pane in Power BI

   The Format pane is where you adjust visual appearance like colors and fonts.

2. Step 2: Select Background color option

   Within the Format pane, you find the Background section to change the color of the visual's background.

3. Final Answer:

   Use the Format pane and select Background color option -> Option A

4. Quick Check:

   Background color changed in Format pane = A [OK]

Hint: Format pane controls visual appearance settings [OK]

Common Mistakes:

• Trying to change background in Data pane
• Right-click menu does not change formatting
• Editing theme JSON is advanced and not needed here

3. You set the font size of a card visual to 20 in the Format pane. What will happen to the card's text?

medium

A. The text will become larger and easier to read

B. The text will become smaller

C. The text color will change to black

D. The card background will become transparent

Solution

1. Step 1: Understand font size effect

   Increasing font size makes text bigger and more readable.

2. Step 2: Apply font size 20 to card visual

   Setting font size to 20 increases the text size compared to default smaller sizes.

3. Final Answer:

   The text will become larger and easier to read -> Option A

4. Quick Check:

   Font size 20 means bigger text = A [OK]

Hint: Larger font size means bigger text [OK]

Common Mistakes:

• Confusing font size with color
• Assuming font size changes background
• Thinking font size makes text smaller

4. You tried to change the title font color in the Format pane, but the color did not update. What is the most likely reason?

medium

A. The data source is not connected

B. You changed the font size instead of color

C. The title is turned off in the Format pane

D. You need to refresh the report to see changes

Solution

1. Step 1: Check if title is enabled

   If the title toggle is off, color changes won't show because title is hidden.

2. Step 2: Confirm title toggle status in Format pane

   Turning on the title toggle allows font color changes to appear.

3. Final Answer:

   The title is turned off in the Format pane -> Option C

4. Quick Check:

   Title off blocks color change = C [OK]

Hint: Title must be on to change its color [OK]

Common Mistakes:

• Confusing font size with color
• Assuming data source affects formatting
• Thinking refresh is needed for formatting

5. You want to highlight sales over $10,000 in a table visual by changing the row background color. Which formatting option should you use?

hard

A. Change the table background color in Format pane

B. Conditional formatting with a rule on Sales column

C. Add a new calculated column with color names

D. Use the Data pane to filter sales over $10,000

Solution

1. Step 1: Understand conditional formatting

   Conditional formatting changes visual style based on data rules, like sales > 10000.

2. Step 2: Apply conditional formatting to table rows

   Use Format pane's conditional formatting on Sales column to set background color for rows meeting the rule.

3. Step 3: Differentiate from other options

   Changing table background affects all rows; calculated columns don't change color automatically; filtering hides data, not format.

4. Final Answer:

   Conditional formatting with a rule on Sales column -> Option B

5. Quick Check:

   Conditional formatting highlights rows = B [OK]

Hint: Use conditional formatting for data-based color changes [OK]

Common Mistakes:

• Changing whole table background instead of rows
• Using calculated columns without formatting
• Filtering data instead of formatting