Gauge visual in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a quick way to see if monthly sales targets are being met using a gauge visual.

📊 Data: You have monthly sales data including Month, Sales Amount, and Sales Target columns.

🎯 Deliverable: Create a Power BI report page with a gauge visual showing actual sales against the target for the current month.

Sample Data

Month	Sales Amount	Sales Target
January	45000	50000
February	52000	50000
March	48000	55000
April	60000	60000
May	58000	60000
June	62000	65000
July	64000	65000
August	70000	70000

1

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

Import the table with columns: Month, Sales Amount, Sales Target. Change the data type of the 'Month' column to Date (e.g., 2024-01-01 for January, 2024-02-01 for February, ..., 2024-08-01 for August).

Expected Result

Data table with 8 rows loaded into Power BI, 'Month' column as Date type.

2

Step 2: Create a measure to get the current month's sales amount.

Current Month Sales = CALCULATE(SUM('Table'[Sales Amount]), LASTDATE('Table'[Month]))

Expected Result

Measure returns the sales amount for the latest month in data (August: 70000).

3

Step 3: Create a measure to get the current month's sales target.

Current Month Target = CALCULATE(SUM('Table'[Sales Target]), LASTDATE('Table'[Month]))

Expected Result

Measure returns the sales target for the latest month in data (August: 70000).

4

Step 4: Insert a Gauge visual on the report canvas.

Add the Gauge visual from the Visualizations pane.

Expected Result

Empty gauge visual appears on the report canvas.

5

Step 5: Configure the Gauge visual with the measures.

Set 'Value' to Current Month Sales measure, 'Target value' to Current Month Target measure, and 'Maximum value' to 1.2 times the target (use 84000).

Expected Result

Gauge shows sales progress for August with needle at 70000, target at 70000, max at 84000.

6

Step 6: Format the Gauge visual for clarity.

Set colors: green for good progress, red for below target. Add data labels and title 'August Sales Performance'.

Expected Result

Gauge visual clearly shows sales status with labels and title.

Final Result

Gauge Visual: August Sales Performance

[=====>           ] 70000 / 70000 Target

Max: 84000

Needle points exactly at target showing sales met.

✓August sales met the target exactly at 70000.

✓The gauge visual quickly shows sales performance status.

✓Maximum value set higher than target to show room for growth.

Bonus Challenge

Create a dynamic gauge visual that updates automatically for the current month based on system date.

Show Hint

Use DAX functions like TODAY() and FILTER to identify current month data dynamically.