Why paginated reports serve formal needs in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a paginated report that fits well on a printed page.

Power BI

Report.Width = [1]

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

A30in

B20in

C8.5in

D15in

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a width too large for standard paper.

Paginated reports are designed to fit standard paper sizes like 8.5 inches wide for printing.

2fill in blank

medium

Complete the code to set the report to display data in a fixed layout for formal presentation.

Power BI

Report.Layout = [1]

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

AFixed

BTablix

CFlexible

DDynamic

Attempts:

3 left

💡 Hint

Common Mistakes

Using flexible layout which can change the look on different pages.

Fixed layout ensures the report looks the same on every page, important for formal reports.

3fill in blank

hard

Fix the error in the expression to calculate total sales in a paginated report.

Power BI

TotalSales = Sum([1])

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

ASalesAmount

BSales.Amount

CAmountSales

DSales[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot notation instead of square brackets.

The correct syntax to sum a column in DAX is Sum(TableName[ColumnName]).

4fill in blank

hard

Fill both blanks to create a filter expression that shows only sales from 2023 in a paginated report.

Power BI

Filter(Sales, Sales[Year] [1] [2])

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

A=

B>

C2023

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Using greater than or less than instead of equals.

The filter should check if the Year column equals 2023 to show only that year's sales.

5fill in blank

hard

Fill both blanks to create a DAX measure that calculates average sales for products with sales greater than 1000.

Power BI

AverageSales = CALCULATE(AVERAGE(Sales[Amount]), FILTER(Sales, Sales[Amount] [1] [2]))

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

A>

B1000

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for filtering.

The filter uses '>' and 1000 to select sales greater than 1000. The last blank is empty because no extra code is needed after FILTER.