Log In
2

Now do it in Power BI Desktop

Visuals: Power BI Desktop exercise

Rebuild the stage's visuals from scratch, then read the numbers off them. You practised this in the browser; now do it in your own copy of Power BI Desktop (free from Microsoft), on the same data, and check your numbers below.

1. Get the data

In Power BI Desktop: Home → Get data → Text/CSV, pick each file, then Load. Check that numbers came in as numbers and dates as dates (Table view, column header icons).

2. The tasks

  1. 1. Sales by country

    Build a clustered bar chart of Sales by Country, sorted from largest to smallest.

  2. 2. Profit by product

    Build a table of Profit by Product. Which product makes the most profit?

  3. 3. Average sale price

    Show the average Sale Price by Segment (change the summarization from Sum to Average).

3. Check your numbers

Try every task first. Then open each answer: the numbers below come from the same data, so yours should match exactly.

1. Sales by country
Total Sales = SUM(financials[Sales])
CountryTotal Sales
Canada24,887,654.88
France24,354,172.29
Germany23,505,340.82
Mexico20,949,352.11
United States of America25,029,830.16
Total118,726,350.26
2. Profit by product
Total Profit = SUM(financials[Profit])
ProductTotal Profit
Amarilla2,814,104.05
Carretera1,826,804.89
Montana2,114,754.88
Paseo4,797,437.94
Velo2,305,992.47
VTT3,034,608.02
Total16,893,702.25
3. Average sale price
Avg Price = AVERAGE(financials[Sale Price])
  • In the Values well, open the field menu and pick Average.
SegmentAvg Price
Channel Partners12
Enterprise125
Government125.67
Midmarket15
Small Business300
Total118.43

The lessons behind this exercise