Bar and column charts in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to see a clear comparison of total sales by product category and by region for the last quarter.

📊 Data: You have sales data including Product Category, Region, and Sales Amount for each transaction in the last quarter.

🎯 Deliverable: Create a Power BI report page with two visuals: a column chart showing total sales by Product Category and a bar chart showing total sales by Region.

Sample Data

TransactionID	ProductCategory	Region	SalesAmount
1	Electronics	North	1200
2	Clothing	South	800
3	Electronics	East	950
4	Furniture	West	700
5	Clothing	North	650
6	Furniture	South	400
7	Electronics	West	1100
8	Clothing	East	900
9	Furniture	North	500
10	Electronics	South	1300
11	Clothing	West	750
12	Furniture	East	600

1

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

Use 'Get Data' > 'Excel/CSV' or paste the data into Power BI.

Expected Result

Sales data table appears in Power BI Fields pane with columns TransactionID, ProductCategory, Region, SalesAmount.

2

Step 2: Create a new measure to calculate total sales amount.

Total Sales = SUM('SalesData'[SalesAmount])

Expected Result

Measure 'Total Sales' is created and sums all sales amounts.

3

Step 3: Insert a column chart visual on the report canvas.

Drag 'ProductCategory' to Axis and 'Total Sales' measure to Values.

Expected Result

Column chart shows total sales for each product category: Electronics, Clothing, Furniture.

4

Step 4: Insert a bar chart visual on the report canvas.

Drag 'Region' to Axis and 'Total Sales' measure to Values.

Expected Result

Bar chart shows total sales for each region: North, South, East, West.

5

Step 5: Format both charts for clarity: add titles, data labels, and adjust colors for accessibility.

Set chart titles to 'Sales by Product Category' and 'Sales by Region'. Enable data labels. Use distinct colors with good contrast.

Expected Result

Charts are easy to read with clear titles and visible sales values.

Final Result

Sales by Product Category

| Electronics | ██████████████ 4550 |
| Clothing    | ████████ 3100     |
| Furniture   | █████ 2200        |

Sales by Region

North | ████████ 2350
South | ███████ 2950
East  | ██████ 2450
West  | █████ 2550

✓Electronics category has the highest total sales.

✓Sales are fairly balanced across regions with South and West slightly higher.

✓Furniture has the lowest sales among product categories.

Bonus Challenge

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

Show Hint

Use the 'Region' field in a slicer visual and test selecting different regions to see filtered sales.

Practice

1. Which type of chart is best to compare sales across different product categories with long names?

easy

A. Bar chart

B. Column chart

C. Pie chart

D. Line chart

Solution

1. Step 1: Understand chart types and category names

   Bar charts display categories horizontally, which works well for long names because text fits better.

2. Step 2: Match chart type to category length

   Column charts show vertical bars and are better for short or time-based categories, not long names.

3. Final Answer:

   Bar chart -> Option A

4. Quick Check:

   Long category names = Bar chart [OK]

Hint: Use bar charts for long category names [OK]

Common Mistakes:

• Choosing column chart for long names
• Confusing pie chart with bar chart
• Using line chart for categorical comparison

2. Which of the following is the correct way to add a title to a bar chart in Power BI?

easy

A. Right-click the chart and type the title directly on bars

B. Select the chart, go to Format pane, and turn on Title under 'Visualizations'

C. Add a text box and place it over the chart without linking

D. Use DAX formula to create a title measure

Solution

1. Step 1: Locate title settings in Power BI

   In Power BI, titles are added via the Format pane under the Visualizations section.

2. Step 2: Enable and edit the title

   Turning on the Title toggle allows you to enter and customize the chart title properly.

3. Final Answer:

   Select the chart, go to Format pane, and turn on Title under 'Visualizations' -> Option B

4. Quick Check:

   Format pane > Title toggle = Select the chart, go to Format pane, and turn on Title under 'Visualizations' [OK]

Hint: Use Format pane to add chart titles [OK]

Common Mistakes:

• Trying to type title directly on bars
• Using unlinked text boxes as titles
• Thinking DAX controls chart titles

3. Given a column chart showing monthly sales, what will happen if you add a filter to show only months with sales above 1000?

medium

A. The chart will convert to a bar chart automatically

B. The chart will show all months but highlight those above 1000

C. The chart will show no data because filters don't apply to visuals

D. The chart will display only columns for months with sales greater than 1000

Solution

1. Step 1: Understand filter effect on visuals

   Filters in Power BI limit the data shown in visuals to only matching records.

2. Step 2: Apply filter condition to monthly sales

   Filtering for sales > 1000 removes months with sales 1000 or less from the chart display.

3. Final Answer:

   The chart will display only columns for months with sales greater than 1000 -> Option D

4. Quick Check:

   Filter hides non-matching data = The chart will display only columns for months with sales greater than 1000 [OK]

Hint: Filters limit data shown in charts [OK]

Common Mistakes:

• Thinking filters highlight but don't remove data
• Assuming filters don't affect visuals
• Expecting chart type to change automatically

4. You created a bar chart but the category labels overlap and are unreadable. What is the best way to fix this?

medium

A. Rotate the category labels or increase chart width

B. Increase the font size of the labels

C. Switch to a column chart to display categories vertically

D. Remove the labels completely

Solution

1. Step 1: Identify cause of label overlap

   Long category names or many categories cause horizontal labels to overlap in bar charts.

2. Step 2: Adjust label orientation or chart size

   Rotating labels or making the chart wider gives more space, improving readability without losing info.

3. Final Answer:

   Rotate the category labels or increase chart width -> Option A

4. Quick Check:

   Label rotation or width fixes overlap = Rotate the category labels or increase chart width [OK]

Hint: Rotate labels or widen chart to fix overlap [OK]

Common Mistakes:

• Switching chart type unnecessarily
• Increasing font size worsens overlap
• Removing labels loses important info

5. You want to create a dashboard showing quarterly revenue trends and compare product categories side by side. Which combination of charts is best?

hard

A. Use a bar chart for quarterly revenue and a column chart for product categories

B. Use two pie charts, one for revenue and one for categories

C. Use a column chart for quarterly revenue and a bar chart for product categories

D. Use a line chart for categories and a stacked bar chart for revenue

Solution

1. Step 1: Match chart types to data nature

   Quarterly revenue is time-based, best shown with column charts for clear trend visualization.

2. Step 2: Choose chart for product categories

   Product categories often have longer names, so bar charts display them horizontally for readability.

3. Step 3: Combine charts for dashboard clarity

   Using column chart for time and bar chart for categories side by side makes comparison easy and clear.

4. Final Answer:

   Use a column chart for quarterly revenue and a bar chart for product categories -> Option C

5. Quick Check:

   Time data = column, long names = bar [OK]

Hint: Time data = column chart; long names = bar chart [OK]

Common Mistakes:

• Using pie charts for trend data
• Mixing chart types incorrectly
• Using bar chart for time series