Documentation standards in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a description to a measure in Power BI.

Power BI

Measure = SUM(Sales[Amount])  -- [1]

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

A"Total sales amount"

B# Total sales amount

C/* Total sales amount */

D// Total sales amount

Attempts:

3 left

💡 Hint

Common Mistakes

Using // for comments which is not supported in DAX

Putting description as a string without comment syntax

In Power BI DAX, comments are added using /* comment */ syntax. This helps document the measure.

2fill in blank

medium

Complete the code to add a tooltip description to a Power BI visual.

Power BI

Visual.Tooltip = [1]

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

A"Shows total sales by region"

BSUM(Sales[Amount])

CCALCULATE(SUM(Sales[Amount]))

DSELECTEDVALUE(Region[Name])

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure or calculation instead of text

Not using quotes around the tooltip text

Tooltips are text descriptions that explain visuals. They should be strings describing the visual.

3fill in blank

hard

Fix the error in the DAX measure documentation comment.

Power BI

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

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

A// Total sales amount

B/* Total sales amount */

C# Total sales amount

D-- Total sales amount

Attempts:

3 left

💡 Hint

Common Mistakes

Using // which is invalid in DAX

Using # or -- which are not comment syntax in DAX

DAX supports block comments with /* */. Using // or # causes errors.

4fill in blank

hard

Fill both blanks to create a descriptive title and subtitle for a Power BI report page.

Power BI

ReportPage.Title = [1]
ReportPage.Subtitle = [2]

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

A"Sales Overview"

B"2024 Q1 Results"

CSUM(Sales[Amount])

DCALCULATE(SUM(Sales[Amount]))

Attempts:

3 left

💡 Hint

Common Mistakes

Using measures or calculations instead of text

Not using quotes around text

Titles and subtitles should be descriptive text strings to help users understand the report content.

5fill in blank

hard

Fill all three blanks to document a calculated column with a description and format string.

Power BI

Profit Margin = DIVIDE(Sales[Profit], Sales[Amount]) [1]
FORMAT(Profit Margin, [2])  -- [3]

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

A/* Calculates profit margin ratio */

B"0.00%"

CProfit margin as percentage

D"#,##0.00%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect comment syntax

Using wrong format string without % sign

Not providing clear description

Use block comments for description, a proper format string for percentage, and a clear comment explaining the format.