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.