Power BI: Visualizing Revenue Performance by Country

In this exercise, we use Power BI to visualize Revenue performance by country using two complementary charts — a column chart and a line chart — built from the Sales and Country tables in our dataset.

The column chart provides a comparative overview of total revenue generated across different countries. This visual is particularly effective for:

• Understanding which countries contribute most to overall revenue.

• Spotting underperforming markets that may need attention.

• Supporting sales and marketing decisions by showing regional performance at a glance.

On the other hand, the line chart focuses on the average revenue per transaction or customer in each country. This visual is crucial when:

• You want to evaluate market efficiency, not just total volume.

• Some countries have more transactions than others — where totals may be misleading.

• Decision-makers need to understand revenue quality or profitability per deal.

Together, these two visuals offer a balanced view:

• The column chart answers “Where is our revenue coming from?”

• The line chart answers “How much revenue do we typically make per transaction or customer in each country?”

By analyzing both, Power BI users can uncover deeper insights — for example, a country may have high total revenue but a low average per sale, suggesting reliance on high volume but low-value sales. Conversely, a smaller market with a high average revenue could indicate a premium segment worth expanding.

Download https://archive.org/download/powerbi_dataset/powerbi_ui_example.xlsx

Step 1 – Load Data

1. Open Power BI Desktop.

2. Click Home → Get Data → Excel.

3. Select the file powerbi_ui_example.xlsx.

4. In the Navigator pane, check the following tables:

   • Sales

   • Country

5. Click Load.

Step 2 – Build the Model Relationship

1. In the Model view (click the third icon on the left sidebar),
   ensure that Sales[Country] is connected to Country[Country].

2. If not automatically linked:

   • Drag Country from Sales and drop it on Country in the Country table.

Step 3 – Create the First Visual (Column Chart: Revenue by Country)

1. Switch to the Report view (first icon on left sidebar).

2. In the Visualizations pane, click the Clustered Column Chart icon (labelled 1 in the image).

3. Drag the following fields:

   • Axis → Sales[Country]

   • Values → Sales[Revenue]

4. Power BI automatically aggregates Revenue (Sum by default).

5. Resize and format the chart as shown in the left side of the image.

   • Title: Revenue by Country_Code

   • Y-axis: Revenue

Step 4 – Create the Second Visual (Line Chart: Average of Revenue by Country)

1. Click on a blank space in the canvas.

2. Select the Line Chart icon in the Visualizations pane (labelled 2).

3. Drag:

   • Axis → Sales[Country]

   • Values → Sales[Revenue]

4. Click the dropdown beside Revenue under Values → select Average (see label 5 in image).

5. Rename the value to Average of Revenue.

6. The chart now shows Average Revenue by Country_Code (right side in the image).

7. Optionally, format the line chart:

   • Change color to blue

   • Add data labels

   • Smooth the line

Step 5 – Adjust and Arrange Charts

1. Place both visuals side by side horizontally.

   • Left chart: Total Revenue by Country

   • Right chart: Average Revenue by Country

2. Align them neatly using the Format → Align → Top option.

3. Add titles for both charts:

   • Chart 1: “Revenue by Country_Code”

   • Chart 2: “Average of Revenue by Country_Code”

Step 6 – Verify Aggregations

In the Fields well (Values section) of each chart:

• Chart 1: Aggregation type is Sum

• Chart 2: Aggregation type is Average

You can verify by clicking the dropdown beside Revenue and confirming the checkmark beside Sum or Average.

Step 7 – Save the Report

1. Click File → Save As → name the file
   Revenue_Comparison_Report.pbix

2. You now have a Power BI file replicating the exact visuals in the image.