Why choosing the right visual matters in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a bar chart visual in Power BI.

Power BI

BarChart = [1](SalesData, 'Product', 'SalesAmount')

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

ABarChart

BBarChartVisual

Cbar_chart

DBarChartVisualize

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect visual names like 'bar_chart' or 'BarChartVisualize'.

In Power BI, the bar chart visual is created using the BarChart function or visual name.

2fill in blank

medium

Complete the DAX measure to calculate total sales for the visual.

Power BI

TotalSales = SUM([1][SalesAmount])

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

ASalesAmount

BSales

CSalesTable

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Using the column name instead of the table name inside SUM.

The SUM function sums the SalesAmount column from the SalesData table.

3fill in blank

hard

Fix the error in the DAX formula to calculate average sales per product.

Power BI

AvgSales = AVERAGE([1][SalesAmount])

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

ASalesData

BSales

CSalesTable

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using the column name alone without the table name.

Using incorrect table names.

The AVERAGE function requires the table name before the column name. SalesData is the correct table.

4fill in blank

hard

Fill both blanks to filter sales data for the year 2023 and calculate total sales.

Power BI

TotalSales2023 = CALCULATE(SUM(SalesData[SalesAmount]), SalesData[Year] [1] [2] 2023)

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

A=

B>

C==

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' instead of '=' for equality.

Using wrong comparison operators like '<' or '>'.

The correct syntax uses a single equals sign = for comparison and the CALCULATE function filters sales where the year equals 2023.

5fill in blank

hard

Fill all three blanks to create a measure that calculates total sales for products with sales greater than 1000.

Power BI

HighSales = CALCULATE(SUM([1][SalesAmount]), FILTER([2], [3][SalesAmount] > 1000))

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

ASalesData

BSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using different table names in the same formula.

Forgetting to use FILTER for row context.

All blanks refer to the SalesData table. The FILTER function filters rows where sales are greater than 1000.