Report design best practices in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the report page size to a standard layout.

Power BI

PageSize = [1]

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

ALetter

BLandscape

CPortrait

DCustom

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing orientation instead of page size

Using 'Custom' without specifying dimensions

Setting the page size to 'Letter' ensures a standard report size for printing and viewing.

2fill in blank

medium

Complete the code to add a slicer visual for filtering data by 'Region'.

Power BI

VisualType = [1]

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

ATable

BCard

CSlicer

DMatrix

Attempts:

3 left

💡 Hint

Common Mistakes

Using Table or Matrix which display data but don't filter

Choosing Card which shows single values

A slicer visual allows users to filter report data interactively by fields like 'Region'.

3fill in blank

hard

Fix the error in the DAX measure to calculate total sales correctly.

Power BI

TotalSales = SUM([1])

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

AAmount[Sales]

BSales[Amount]

CSalesAmount

DTotal[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using column name without table

Reversing table and column names

The correct syntax for SUM requires the table and column name in the format Table[Column].

4fill in blank

hard

Fill both blanks to create a measure that calculates average sales per region.

Power BI

AvgSalesPerRegion = AVERAGEX(VALUES([1]), CALCULATE(SUM([2])))

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

ASales[Region]

BSales[Amount]

CRegion[Sales]

DAmount[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping table and column names

Using incorrect table names

VALUES(Sales[Region]) gets unique regions, and SUM(Sales[Amount]) sums sales per region for averaging.

5fill in blank

hard

Fill all three blanks to create a calculated column that flags high sales over 1000.

Power BI

HighSalesFlag = IF([1] > [2], [3], "No")

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

ASales[Amount]

B1000

C"Yes"

DSales[Region]

Attempts:

3 left

💡 Hint

Common Mistakes

Using region column instead of amount

Using number as string incorrectly

This IF statement checks if Sales[Amount] is greater than 1000, then flags "Yes", else "No".