Why choosing the right visual matters in Power BI - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants a report that clearly shows monthly sales performance and product category comparisons to help decide where to focus marketing efforts.

📊 Data: You have sales data with columns: Date, Product Category, Sales Amount, and Region for the last 6 months.

🎯 Deliverable: Create a Power BI report with visuals that best represent monthly sales trends and category comparisons, making it easy for the manager to understand and act on.

Sample Data

Date	Product Category	Sales Amount	Region
2024-01-15	Electronics	12000	North
2024-01-20	Clothing	8000	South
2024-02-10	Electronics	15000	North
2024-02-18	Clothing	7000	South
2024-03-05	Electronics	13000	East
2024-03-22	Clothing	9000	East
2024-04-12	Electronics	16000	West
2024-04-25	Clothing	8500	West
2024-05-15	Electronics	17000	North
2024-05-30	Clothing	9500	North
2024-06-10	Electronics	18000	South
2024-06-20	Clothing	10000	South

1

Step 1: Load the sales data into Power BI and create a Date table for time intelligence.

Use Power BI's 'Get Data' to import the table. Then create a Date table using DAX: Date = CALENDAR(MIN(Sales[Date]), MAX(Sales[Date]))

Expected Result

Data loaded and Date table created covering all sales dates.

2

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

Total Sales = SUM(Sales[Sales Amount])

Expected Result

Measure 'Total Sales' sums all sales amounts correctly.

3

Step 3: Create a line chart visual to show monthly sales trend over time.

Configure visual: Axis = Date[Date], Values = Total Sales; use 'Month' from Date table or create a Month column for grouping

Expected Result

Line chart shows total sales for each month from January to June.

4

Step 4: Create a clustered bar chart to compare total sales by product category.

Configure visual: Axis = Sales[Product Category], Values = Total Sales

Expected Result

Bar chart displays total sales for Electronics and Clothing side by side.

5

Step 5: Add data labels and clear titles to both visuals for easy understanding.

Enable data labels in visual formatting pane; set titles: 'Monthly Sales Trend' and 'Sales by Product Category'

Expected Result

Visuals have clear titles and data labels showing exact sales values.

6

Step 6: Explain why these visuals were chosen: line chart for trends, bar chart for category comparison.

No formula; explanation: Line charts show changes over time clearly; bar charts compare categories side by side effectively.

Expected Result

Manager understands the choice of visuals helps quick and accurate decision-making.

Final Result

Monthly Sales Trend (Line Chart)

Jan  Feb  Mar  Apr  May  Jun
|     |     |     |     |     |
|     |     |     |     |     |
|     |     |     |     |     |
|_____|_____|_____|_____|_____|_____

Sales by Product Category (Bar Chart)

Electronics: ██████████████  91,000
Clothing:    ██████████      53,000

✓Sales increased steadily from January to June.

✓Electronics sales are significantly higher than Clothing sales.

✓Line chart helps see the trend over months clearly.

✓Bar chart makes it easy to compare product categories at a glance.

Bonus Challenge

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

Show Hint

Use the Region column as a slicer field; connect slicer to both visuals to filter data interactively.