Bar and column charts in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic bar chart visual in Power BI using the 'Sales' field.

Power BI

BarChart = SUMMARIZE(SalesData, SalesData[Product], "TotalSales", SUM(SalesData[[1]]))

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

AQuantity

BCustomer

CDate

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric field like 'Date' or 'Customer' for summing.

The 'Sales' field is used to sum total sales for each product, which is essential for a bar chart showing sales amounts.

2fill in blank

medium

Complete the DAX measure to calculate total sales for the column chart.

Power BI

TotalSales = CALCULATE(SUM(SalesData[[1]]))

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

AQuantity

BSales

CDiscount

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Quantity' or 'Discount' which do not represent total sales amount.

The measure sums the 'Sales' column to get total sales, which is used in column charts to show aggregated sales.

3fill in blank

hard

Fix the error in the DAX formula to correctly calculate total sales for the bar chart.

Power BI

TotalSales = SUM(SalesData[[1]])

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

ASales

BDate

CCustomer

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to sum non-numeric columns like 'Date' or 'Customer'.

The SUM function must be applied to the 'Sales' column to calculate total sales correctly.

4fill in blank

hard

Fill both blanks to create a bar chart showing total sales by region.

Power BI

BarChart = SUMMARIZE(SalesData, SalesData[[1]], "TotalSales", SUM(SalesData[[2]]))

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

ARegion

BSales

CProduct

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Grouping by 'Product' or 'Date' instead of 'Region' for this chart.

The bar chart groups data by 'Region' and sums the 'Sales' to show total sales per region.

5fill in blank

hard

Fill all three blanks to create a column chart measure that calculates total sales filtered by year 2023.

Power BI

TotalSales2023 = CALCULATE(SUM(SalesData[[1]]), SalesData[[2]] = [3])

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

AQuantity

BSales

CYear

D2023

Attempts:

3 left

💡 Hint

Common Mistakes

Filtering by wrong column or using a non-numeric field for sum.

This measure sums the 'Sales' column but only for rows where the 'Year' is 2023, useful for a column chart filtered by year.