Bookmarks for filter states in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What does a bookmark save in Power BI?

In Power BI, when you create a bookmark, what exactly does it save?

A The raw data source connection details.

B Only the data model structure and relationships.

C The current filter and slicer states, visual selections, and the page view.

D The report theme colors and fonts only.

💡 Hint

Think about what you want to return to when you click a bookmark.

A bookmark saves the current filter and slicer states, visual selections, and the page view so you can return to that exact report state later.

❓ dax_lod_result

intermediate

DAX measure effect with bookmark filter state

Given a report with a bookmark that saves a filter on 'Region' = 'West', what will the following DAX measure return when the bookmark is applied?

Sales in Region = CALCULATE(SUM(Sales[Amount]))

A Zero, because bookmarks disable measures.

B The sum of sales only for the 'West' region.

C The sum of sales for all regions ignoring the bookmark filter.

D An error because bookmarks do not affect DAX.

💡 Hint

Bookmarks apply filters visually, which affect measure calculations.

The bookmark applies a filter on 'Region' = 'West', so the measure calculates sales only for that region.

❓ visualization

advanced

Best practice for bookmark navigation buttons

You want to create a report page with buttons that switch between different bookmark states showing various filter combinations. Which practice ensures the best user experience?

A Use clearly labeled buttons with descriptive text and set the button action to 'Bookmark'.

B Use images without labels and assign bookmarks randomly to buttons.

C Use slicers instead of bookmarks for navigation buttons.

D Create bookmarks but do not link them to any buttons; users must find them in the bookmark pane.

💡 Hint

Think about clarity and ease of use for report consumers.

Using clearly labeled buttons with bookmark actions helps users understand and easily switch between saved filter states.

🔧 Formula Fix

advanced

Why does a bookmark not restore filter state?

You created a bookmark saving a filter on 'Product Category' = 'Bikes'. When you apply the bookmark, the filter does not change. What is the most likely cause?

A The report page is in edit mode, so bookmarks do not work.

B The data model does not contain the 'Product Category' column.

C Bookmarks cannot save filter states on slicers.

D The bookmark was created without selecting 'Data' option to save filter states.

💡 Hint

Check the bookmark settings carefully.

If the 'Data' option is not checked when creating a bookmark, filter and slicer states are not saved or restored.

🎯 Scenario

expert

Using bookmarks to create a dynamic report with multiple filter states

You want to build a sales report that lets users switch between yearly sales, quarterly sales, and monthly sales views using bookmarks. Each view has different slicer selections and visual configurations. What is the best approach to implement this?

A Create separate bookmarks for each view saving slicer selections and visual states, then add buttons linked to these bookmarks for user navigation.

B Create one bookmark and manually change slicers each time users want a different view.

C Use multiple report pages instead of bookmarks to separate views.

D Use DAX measures only to switch views without bookmarks or buttons.

💡 Hint

Think about user convenience and report interactivity.

Bookmarks can save different filter and visual states. Linking them to buttons allows users to switch views easily without manual changes.