Parameters in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a report where they can select a sales target amount and see which products meet or exceed that target.

📊 Data: You have sales data with columns: Product, Category, Sales Amount, and Date.

🎯 Deliverable: Create a Power BI report with a parameter to input the sales target and a table showing products with sales above that target.

Sample Data

Product	Category	Sales Amount	Date
Notebook	Stationery	1200	2024-01-15
Pen	Stationery	800	2024-01-20
Desk Chair	Furniture	1500	2024-01-18
Monitor	Electronics	2000	2024-01-22
Mouse	Electronics	700	2024-01-25
Stapler	Stationery	400	2024-01-28
Bookshelf	Furniture	1300	2024-01-30
Keyboard	Electronics	900	2024-01-27

1

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

Use 'Get Data' to import the table with columns Product, Category, Sales Amount, and Date.

Expected Result

Sales data is loaded and visible in the Fields pane.

2

Step 2: Create a numeric parameter for sales target input.

In Power BI Desktop, go to Modeling > New Parameter > Numeric Range. Name it 'Sales Target'. Set minimum=0, maximum=3000, increment=100, default=1000.

Expected Result

A slicer appears on the report page allowing selection of sales target values.

3

Step 3: Create a measure to filter products with sales above the selected target.

Filtered Sales = IF(SUM('Sales'[Sales Amount]) >= SELECTEDVALUE('Sales Target'[Sales Target Value]), SUM('Sales'[Sales Amount]), BLANK())

Expected Result

Measure returns sales amount only for products meeting or exceeding the selected target.

4

Step 4: Add a table visual to the report showing Product, Category, and the new measure 'Filtered Sales'.

Insert Table visual. Add fields: Product, Category, Filtered Sales measure.

Expected Result

Table shows only products with sales above the selected target; others show blank and are hidden.

5

Step 5: Set visual-level filter on the table to show only rows where 'Filtered Sales' is not blank.

In Filters pane for the table, add 'Filtered Sales' measure filter: is not blank.

Expected Result

Table displays only products with sales equal or above the selected sales target.

Final Result

Sales Target Parameter Report

+----------------+------------+----------------+
| Product        | Category   | Filtered Sales |
+----------------+------------+----------------+
| Monitor        | Electronics| 2000           |
| Desk Chair     | Furniture  | 1500           |
| Bookshelf      | Furniture  | 1300           |
| Notebook       | Stationery | 1200           |
+----------------+------------+----------------+

[Sales Target Slicer: 1000]

✓Products with sales above the selected target are clearly listed.

✓Changing the sales target dynamically updates the product list.

✓This helps management focus on top-performing products.

Bonus Challenge

Add a parameter to select product category and filter the table accordingly.

Show Hint

Create a text parameter with category options and use it in a measure or visual filter to show only selected category products.