Why advanced visuals reveal deeper insights in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic bar chart visual in Power BI.

Power BI

BarChart = SUMMARIZE(Sales, Sales[Product], "TotalSales", [1](Sales[Amount]))

Drag options to blanks, or click blank then click option'

AMIN

BSUM

CCOUNT

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of SUM, which counts rows not sums values.

The SUM function adds all sales amounts for each product, which is essential for a bar chart showing total sales.

2fill in blank

medium

Complete the DAX measure to calculate the average sales per customer.

Power BI

AvgSalesPerCustomer = DIVIDE(SUM(Sales[Amount]), [1](Sales[CustomerID]))

Drag options to blanks, or click blank then click option'

ASUM

BMAX

CCOUNTROWS

DDISTINCTCOUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNTROWS counts all rows, not unique customers.

DISTINCTCOUNT counts unique customers, which is needed to find average sales per customer.

3fill in blank

hard

Fix the error in this DAX formula to calculate year-to-date sales.

Power BI

YTD_Sales = TOTALYTD(SUM(Sales[Amount]), Sales[[1]])

Drag options to blanks, or click blank then click option'

AProduct

BCustomerID

CDate

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-date columns like CustomerID or Product causes errors.

The TOTALYTD function requires a date column to calculate year-to-date values correctly.

4fill in blank

hard

Fill both blanks to create a calculated table showing total sales by region and year.

Power BI

SalesByRegionYear = SUMMARIZE(Sales, Sales[[1]], Sales[[2]], "TotalSales", SUM(Sales[Amount]))

Drag options to blanks, or click blank then click option'

ARegion

BYear

CProduct

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Grouping by Product or CustomerID does not show sales by region and year.

Grouping by Region and Year allows the table to show total sales for each region per year.

5fill in blank

hard

Fill all three blanks to create a measure that calculates sales growth percentage compared to the previous year.

Power BI

SalesGrowth% = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Sales[[1]])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Sales[[2]])), 0) * [3]

Drag options to blanks, or click blank then click option'

ADate

C100

DAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Amount instead of Date in time functions causes errors.

The Date column is needed for time comparison functions like SAMEPERIODLASTYEAR. Multiplying by 100 converts the ratio to a percentage.