Waterfall charts in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a measure that calculates the total sales for the waterfall chart.

Power BI

Total Sales = SUM([1][SalesAmount])

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

ASalesData

BCustomer

CProduct

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension table instead of the fact table for sales.

The measure sums the SalesAmount column from the SalesData table, which is the correct source for sales values in the waterfall chart.

2fill in blank

medium

Complete the code to calculate the running total for the waterfall chart.

Power BI

Running Total = CALCULATE(SUM(SalesData[SalesAmount]), FILTER(ALLSELECTED(SalesData), SalesData[Date] <= [1][Date]))

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

ADate

BSalesData

CProduct

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-date column in the filter condition.

The running total sums sales up to the current date, so the filter compares dates using the Date column.

3fill in blank

hard

Fix the error in the measure that calculates the change between periods for the waterfall chart.

Power BI

Change = SUM(SalesData[SalesAmount]) - CALCULATE(SUM(SalesData[SalesAmount]), PREVIOUSMONTH([1][Date]))

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

ACustomer

BSalesAmount

CDate

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-date column inside PREVIOUSMONTH.

The PREVIOUSMONTH function requires a date column to calculate the previous period correctly.

4fill in blank

hard

Fill both blanks to create a measure that calculates the cumulative change for the waterfall chart.

Power BI

Cumulative Change = CALCULATE(SUM(SalesData[SalesAmount]), FILTER(ALL(SalesData), SalesData[Date] [1] MAX(SalesData[Date]) && SalesData[Date] [2] MIN(SalesData[Date])))

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

A<=

B>=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators that exclude needed dates.

The filter keeps dates less than or equal to the max date and greater than or equal to the min date to calculate cumulative change correctly.

5fill in blank

hard

Fill all three blanks to create a measure that calculates the net change excluding a specific category for the waterfall chart.

Power BI

Net Change Excl = CALCULATE(SUM(SalesData[SalesAmount]), SalesData[Category] [1] "[2]", FILTER(ALL(SalesData), SalesData[Date] [3] MAX(SalesData[Date])))

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

A<>

BElectronics

C<=

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using equal operator instead of not equal.

Incorrect date filter operator.

The measure excludes the 'Electronics' category using <> (not equal) and filters dates up to the max date with <=.