What is the total Units Sold for the 4 countries? What is % of the Grand Total for the 4 countries?

Question 1

In PowerBI:

1. In the table Dataset: Create a new column named % of Grand Total by using the appropriate Expression to divide the Total Units by the SUM of the Total Units. Format the new column as percentage, 2 decimals. Enter yes, if completed

Question 2

In PowerBI:

1. Create a new measure, named Sales in $, which multiplies the Units Sold, from the Dataset table, with the Unit Price, from the related Product table. Format this new measure as Currency, 0 decimals. Enter Yes, if completed

Question 3

In PowerBI:

Create a new Report.

On Page 1, create the following visualizations:

1. Table Visualization: Add the following fields to the table: Country, Units Sold, % of Grand Total. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt.

Adjust columns as required to show data. Enter yes, if completed.

2. Clustered Column Chart Visualization. Add the following fields to the chart: Country and Units Sold. Format the Data color: #a8337d Theme color 5, 25% darker. Enter yes, if completed.

What is the total Units Sold for all countries?

3. Apply the following Filter to the Page to show the values for the following countries only: Germany, Mexico, Thailand, United Kingdom. Enter yes, if completed.

4. Change the name of Page 1 to your First Name, e.g. Maria

What is the total Units Sold for the 4 countries?

What is % of the Grand Total for the 4 countries?

Which of the 4 countries has the highest total Units Sold? What is this number?

Which of the 4 countries has the lowest total Units Sold? What is this number?

Question 4

In PowerBI:

On Page 2, create the following visualizations:1.

Table Visualization: Add the following fields to the table: Product Code, Description, Units Sold, % of Grand Total. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show data. Enter yes, if completed.

2. Clustered Bar Chart Visualization. Add the following fields to the chart: Product Code and Units Sold. Format the Data color: #a0a7d8, Theme color 2, 60% lighter. Enter yes, if completed.

3. Apply the following Filter to the Page to show the following products: PC1429, PG4152, PO2382, PZ2297. Enter yes, if completed.

What is the total Units Sold for the 4 products?

What is % of the Grand Total for the 4 products?

Which of the 4 products (Product code) has the highest total Units Sold? What is this number?

Which of the 4 products (Product code) has the lowest total Units Sold?

What is this number?