Bookmarks for filter states in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a bookmark that saves the current filter state.

Power BI

Bookmarks pane > [1] > Add

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

AUpdate Bookmark

BDelete Bookmark

CRename Bookmark

DNew Bookmark

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Delete Bookmark' instead of creating a new one.

Selecting 'Rename Bookmark' which only changes the name.

To save the current filter state, you click New Bookmark in the Bookmarks pane.

2fill in blank

medium

Complete the code to update an existing bookmark with the current filter state.

Power BI

Select bookmark > [1]

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

AUpdate

BDelete

CRename

DAdd

Attempts:

3 left

💡 Hint

Common Mistakes

Clicking 'Delete' which removes the bookmark.

Choosing 'Rename' which only changes the bookmark's name.

To save changes to an existing bookmark's filter state, use the Update option.

3fill in blank

hard

Fix the error in the DAX expression to create a measure that shows if a bookmark is selected.

Power BI

IsBookmarkSelected = IF(SELECTEDVALUE(Bookmarks[Name]) = [1], 1, 0)

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

A"CurrentBookmark"

BCurrentBookmark

CBookmarks[Current]

DBookmarkName

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted text which causes a syntax error.

Using a column name that does not exist.

The bookmark name must be a text string in quotes in DAX, so use "CurrentBookmark".

4fill in blank

hard

Fill both blanks to create a bookmark that captures filters and visuals but not the display state.

Power BI

Create Bookmark > Options: [1] = ON, [2] = OFF

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

AData

BDisplay

CCurrent Page

DVisuals

Attempts:

3 left

💡 Hint

Common Mistakes

Turning Display ON which saves visual states.

Turning Data OFF which loses filter states.

To save filters and visuals, turn Data ON and Display OFF.

5fill in blank

hard

Fill all three blanks to write a DAX measure that counts how many bookmarks have the word 'Sales' in their name.

Power BI

SalesBookmarksCount = CALCULATE(COUNTROWS(Bookmarks), FILTER(Bookmarks, SEARCH([1], Bookmarks[Name], 1, [3]) [2] 0))

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

A"Sales"

B>

C0

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the search text.

Using wrong comparison operators.

The SEARCH function looks for the text "Sales". If the result is greater than 0, it means 'Sales' is found.