Funnel charts in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a funnel chart visual in Power BI by specifying the correct field for the stages.

Power BI

FunnelChart = FunnelChartVisual(StageField = [1])

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

ASalesAmount

BSalesStage

CCustomerName

DOrderDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a numeric value field instead of a categorical stage field.

Choosing a date or customer name field which does not represent funnel stages.

The funnel chart requires a field that represents the stages of the funnel, such as 'SalesStage'.

2fill in blank

medium

Complete the DAX measure to calculate the total sales amount for the funnel chart.

Power BI

TotalSales = CALCULATE(SUM([1]))

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

ASalesAmount

BSalesStage

CCustomerID

DOrderDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a categorical field like 'SalesStage' inside SUM.

Using a non-numeric field such as 'CustomerID' or 'OrderDate'.

The measure sums the 'SalesAmount' field to show total sales in the funnel chart.

3fill in blank

hard

Fix the error in the DAX formula to calculate the conversion rate between funnel stages.

Power BI

ConversionRate = DIVIDE(SUM(Sales[SalesAmount]), [1])

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

ASUM(Sales[CustomerID])

BSUM(Sales[SalesStage])

CSUM(Sales[PreviousStageAmount])

DSUM(Sales[OrderDate])

Attempts:

3 left

💡 Hint

Common Mistakes

Using a categorical field like 'SalesStage' in SUM.

Using non-numeric fields like 'CustomerID' or 'OrderDate'.

The denominator should be the sum of sales amount from the previous stage to calculate conversion rate correctly.

4fill in blank

hard

Fill both blanks to create a filter that shows only funnel stages with sales above 1000.

Power BI

FILTER(Sales, Sales[SalesAmount] [1] 1000 && Sales[[2]] <> "")

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

A>

B<

CSalesStage

DCustomerName

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for sales amount comparison.

Using a non-stage field like 'CustomerName' in the second blank.

The filter keeps sales amounts greater than 1000 and ensures the stage field is not empty.

5fill in blank

hard

Fill all three blanks to create a calculated table summarizing sales by funnel stage and sorting by sales descending.

Power BI

SummaryTable = SUMMARIZE(Sales, Sales[[1]], "TotalSales", SUM(Sales[[2]]))
SummaryTableSorted = SORTBY(SummaryTable, SummaryTable[[3]], DESC)

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

ASalesStage

BSalesAmount

CTotalSales

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Grouping by a numeric field instead of the stage.

Sorting by a field not present in the summary table.

The table groups by 'SalesStage', sums 'SalesAmount', and sorts by the calculated 'TotalSales' column descending.