Microsoft Power BI Data Analyst Practice Question

You are editing a Power BI Desktop report that contains five pages: Overview, Regional, Product, Margin, and Forecast. A Date hierarchy slicer exists on the Overview page. Business users ask that whatever Date range they pick in the slicer should automatically filter visuals on the Regional and Product pages, but the slicer itself must not be displayed on those pages. The Margin and Forecast pages must remain unaffected. Which feature should you use to implement this requirement?

  • Open the Sync slicers pane, tick the Sync boxes for the Regional and Product pages, and clear their Visible boxes.

  • Enable "Filter on all pages" for the slicer in its Format pane.

  • Duplicate the slicer onto the Regional and Product pages and use Edit interactions to hide its effect on the other pages.

  • Add the Date field as a report-level filter, lock the filter, and remove the slicer from the canvas.

Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot