Formatting for print in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to format the measure as currency with two decimals.

Power BI

Formatted Sales = FORMAT(SUM(Sales[Amount]), [1])

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

A"Currency"

B"General Number"

C"$#,##0.00"

D"Percent"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "Currency" as a string does not format the number correctly.

Using "Percent" will multiply the number by 100 and add a percent sign.

Using "$#,##0.00" formats the number as currency with two decimal places.

2fill in blank

medium

Complete the code to format the date as day-month-year.

Power BI

Formatted Date = FORMAT(Sales[Date], [1])

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

A"DD-MM-YYYY"

B"MM/DD/YYYY"

C"YYYY/MM/DD"

D"MMMM DD, YYYY"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "MM/DD/YYYY" shows month first, not day.

Using "MMMM DD, YYYY" shows the full month name, not numeric.

The format string "DD-MM-YYYY" displays the date as day-month-year.

3fill in blank

hard

Fix the error in the code to format the percentage with one decimal place.

Power BI

Formatted Percentage = FORMAT(Sales[Percent], [1])

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

A"0.00%"

B"0.0%"

C"Percent"

D"#0.0"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "Percent" formats with no decimal places.

Using "#0.0" does not add the percent sign.

The format string "0.0%" formats the number as a percentage with one decimal place.

4fill in blank

hard

Fill both blanks to format the sales amount with thousand separator and no decimals.

Power BI

Formatted Sales = FORMAT(SUM(Sales[Amount]), [1] & [2])

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

A"#,##0"

B"$"

C"0.00"

D"%"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the number format before the dollar sign.

Using decimals when none are needed.

Concatenating "$" and "#,##0" formats the number with a dollar sign and thousand separators without decimals.

5fill in blank

hard

Fill all three blanks to format the average discount as a percentage with no decimals and add a custom text suffix.

Power BI

Formatted Discount = FORMAT(AVERAGE(Sales[Discount]), [1]) & [2] & [3]

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

A"0%"

B" "

C" off"

D"%"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "%" alone does not format decimals correctly.

Forgetting to add a space before the suffix.

Adding suffix without formatting the number.

Using "0%" formats the number as a percentage with no decimals. Adding a space " " and the text " off" creates a readable suffix like "25% off".