Dashboards vs reports in Power BI - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Power BI report page showing sales data.

Power BI

ReportPage = PowerBI.CreatePage([1])

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

AFilterPanel

BDashboardView

CSummaryTile

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashboard or tile names instead of dataset name.

Confusing report page with dashboard view.

The report page is created using the dataset name, here 'SalesData'.

2fill in blank

medium

Complete the code to add a tile to a Power BI dashboard.

Power BI

Dashboard.AddTile([1])

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

ACreateReport()

BCreatePage()

CCreateTile()

DCreateFilter()

Attempts:

3 left

💡 Hint

Common Mistakes

Using CreatePage() which is for reports.

Using CreateReport() which is not a tile.

Dashboards are made of tiles, so you add a tile using CreateTile().

3fill in blank

hard

Fix the error in the code to filter a report visual by region.

Power BI

ReportVisual.Filter = [1]('Region', 'East')

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

AApplyFilter

BSetFilter

CAddFilter

DUseFilter

Attempts:

3 left

💡 Hint

Common Mistakes

Using ApplyFilter which is not a valid method.

Using AddFilter which is incorrect here.

SetFilter is the correct method to filter visuals in Power BI reports.

4fill in blank

hard

Fill both blanks to create a dashboard tile from a report visual.

Power BI

DashboardTile = Dashboard.CreateTile([1], [2])

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

AReportVisual

BReportPage

CTileName

DDashboardName

Attempts:

3 left

💡 Hint

Common Mistakes

Using ReportPage instead of ReportVisual.

Using DashboardName instead of TileName.

You create a tile from a report visual and give it a tile name.

5fill in blank

hard

Fill all three blanks to define a measure that sums sales and use it in a report visual.

Power BI

Measure = CALCULATE(SUM([1][[2]]))
ReportVisual.Value = [3]

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

ASalesData

BAmount

CMeasure

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong table or column names.

Assigning the wrong variable to the visual.

The measure sums the 'Amount' column from 'SalesData' and is assigned to the visual's value.