This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Create reports
      --> Create Visual Calculations by Using DAX

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

Question 1

You need to calculate a percent-of-total value that is only required in a single table visual. Which approach is most appropriate?

A. Create a calculated column
B. Create a reusable DAX measure
C. Create a visual calculation
D. Create a Power Query custom column

Correct Answer: C. Create a visual calculation

Explanation:
Visual calculations are ideal for visual-specific logic that does not need to be reused elsewhere in the model.

---

Question 2

Which statement best describes a visual calculation?

A. A reusable calculation stored in the data model
B. A calculation evaluated during data refresh
C. A DAX calculation scoped to a single visual
D. A calculation written only in Power Query

Correct Answer: C. A DAX calculation scoped to a single visual

Explanation:
Visual calculations exist only within the visual in which they are created and are not reusable across the report.

---

Question 3

A report author wants to reduce clutter in the semantic model by avoiding unnecessary measures. What feature supports this goal?

A. Calculated tables
B. Visual calculations
C. Drillthrough filters
D. Bookmarks

Correct Answer: B. Visual calculations

Explanation:
Visual calculations allow you to perform analysis without adding extra measures to the model.

---

Question 4

Which scenario is best suited for a traditional DAX measure instead of a visual calculation?

A. A quick ranking used in one chart
B. A running total used only once
C. A business KPI used across multiple reports
D. A percent-of-total in a single matrix

Correct Answer: C. A business KPI used across multiple reports

Explanation:
Reusable and standardized business logic should be implemented as model measures, not visual calculations.

---

Question 5

Visual calculations are evaluated based on which context?

A. Row context only
B. Report-level filter context
C. The visual’s data and layout context
D. The entire dataset

Correct Answer: C. The visual’s data and layout context

Explanation:
Visual calculations operate on the data displayed in the visual, including its grouping, ordering, and filters.

---

Question 6

Which type of calculation is commonly implemented using visual calculations?

A. Row-level security rules
B. Calculated columns
C. Difference between consecutive rows
D. Data cleansing logic

Correct Answer: C. Difference between consecutive rows

Explanation:
Visual calculations excel at comparisons across visible rows, such as previous vs. current values.

---

Question 7

A visual calculation is created in a matrix visual. What happens if the visual is removed from the report?

A. The calculation becomes a measure
B. The calculation remains in the model
C. The calculation is deleted with the visual
D. The calculation moves to another visual

Correct Answer: C. The calculation is deleted with the visual

Explanation:
Visual calculations are tied directly to the visual and do not exist independently in the model.

---

Question 8

Which limitation should you consider before choosing a visual calculation?

A. They cannot reference DAX functions
B. They cannot respond to slicers
C. They are not reusable across visuals
D. They require Premium licensing

Correct Answer: C. They are not reusable across visuals

Explanation:
Visual calculations are limited to a single visual and cannot be shared or reused elsewhere.

---

Question 9

A user asks for a month-over-month comparison that is needed only in one line chart. What is the best solution?

A. Create a calculated column
B. Create a visual calculation
C. Create a calculated table
D. Modify the data source

Correct Answer: B. Create a visual calculation

Explanation:
For one-off comparisons in a single visual, visual calculations provide a fast and efficient solution.

---

Question 10

Which exam scenario most strongly indicates that a visual calculation should be used?

A. The calculation must be consistent across all reports
B. The calculation affects row-level security
C. The calculation is exploratory and visual-specific
D. The calculation must be used in multiple visuals

Correct Answer: C. The calculation is exploratory and visual-specific

Explanation:
Visual calculations are designed for ad hoc, visual-level analysis, not enterprise-wide logic.

---

Exam-Day Reminder

When the PL-300 question emphasizes:

• One visual only
• Quick analysis
• Reducing model complexity
• Non-reusable logic

👉 Visual calculation is likely to be a possible correct answer.

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure Bookmarks

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

Question 1

What is the primary purpose of bookmarks in Power BI?

A. To store data snapshots
B. To improve query performance
C. To capture and restore report states
D. To manage user security

Correct Answer: C. To capture and restore report states

Explanation:
Bookmarks save the state of a report page, including filters, slicers, and visual visibility, allowing users to return to that state later.

---

Question 2

Which bookmark option controls whether slicer and filter selections are stored?

A. Display
B. Data
C. Current page
D. Spotlight

Correct Answer: B. Data

Explanation:
The Data option determines whether the bookmark captures filter and slicer selections.

---

Question 3

You want a button that resets all slicers on a page to their default values. What feature should you use?

A. Drillthrough
B. Visual interactions
C. A bookmark with data enabled
D. A synced slicer

Correct Answer: C. A bookmark with data enabled

Explanation:
A bookmark that captures the default filter state can be linked to a button to reset slicers.

---

Question 4

Which scenario is best suited for bookmarks rather than drillthrough?

A. Navigating to a detail page with context
B. Showing a filtered view of another report
C. Toggling between summary and detailed visuals on the same page
D. Analyzing data at a lower grain

Correct Answer: C. Toggling between summary and detailed visuals on the same page

Explanation:
Bookmarks are ideal for changing visual visibility and guiding users within the same page.

---

Question 5

Which bookmark setting controls whether visuals are shown or hidden?

A. Data
B. Filters
C. Display
D. Current page

Correct Answer: C. Display

Explanation:
The Display option captures visual visibility, spotlight, and focus mode settings.

---

Question 6

What happens if a visual is removed after a bookmark is created?

A. The bookmark automatically updates
B. The bookmark fails to work
C. The bookmark may no longer behave as expected
D. The visual is restored by the bookmark

Correct Answer: C. The bookmark may no longer behave as expected

Explanation:
Bookmarks are static snapshots. Changes to visuals can cause bookmarks to become outdated or inconsistent.

---

Question 7

Which feature is commonly used together with bookmarks to improve report navigation?

A. Tooltips
B. Buttons
C. KPIs
D. Calculated columns

Correct Answer: B. Buttons

Explanation:
Buttons are often configured to trigger bookmarks, enabling interactive navigation and storytelling.

---

Question 8

Which bookmark option ensures the bookmark applies only to the active page?

A. Data
B. Display
C. Current page
D. Page navigation

Correct Answer: C. Current page

Explanation:
The Current page option restricts the bookmark’s effect to the page where it was created.

---

Question 9

Which of the following is a limitation of bookmarks?

A. They cannot be used with slicers
B. They require Premium licensing
C. They store static report states
D. They cannot be triggered by buttons

Correct Answer: C. They store static report states

Explanation:
Bookmarks do not dynamically update; they restore the saved state, which may become outdated if the report changes.

---

Question 10

An exam question describes a report that guides users step-by-step through insights using buttons. What feature is being described?

A. Drillthrough
B. Bookmarks
C. Sync slicers
D. Visual calculations

Correct Answer: B. Bookmarks

Explanation:
Guided storytelling and step-by-step navigation are classic bookmark use cases.

---

Exam-Day Reminder

If a PL-300 question mentions:

• Buttons
• Resetting filters
• Guided storytelling
• Showing or hiding visuals
• Saving report states

👉 The correct answer is almost always Bookmarks.

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Create custom tooltips

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

Question 1

What is the primary purpose of a custom tooltip in Power BI?

A. To improve dataset refresh performance
B. To provide additional contextual insights on hover
C. To navigate to another report page
D. To apply row-level security

Correct Answer: B. To provide additional contextual insights on hover

Explanation:
Custom tooltips enhance reports by delivering rich, on-demand information when users hover over a visual element.

---

Question 2

How are custom tooltips created in Power BI?

A. By adding fields to the Tooltip well
B. By creating a calculated table
C. By creating a report page and enabling it as a tooltip
D. By configuring drillthrough filters

Correct Answer: C. By creating a report page and enabling it as a tooltip

Explanation:
Custom tooltips are implemented using dedicated report pages that are configured for tooltip use.

---

Question 3

Which advantage do custom tooltips have over default tooltips?

A. They support data entry
B. They allow cross-filtering
C. They can include multiple visuals
D. They refresh data in real time

Correct Answer: C. They can include multiple visuals

Explanation:
Unlike default tooltips, custom tooltips can display charts, KPIs, and formatted visuals.

---

Question 4

A report designer wants to reduce visual clutter while still providing detailed insights. What feature should they use?

A. Drillthrough pages
B. Custom tooltips
C. Bookmarks
D. Visual-level filters

Correct Answer: B. Custom tooltips

Explanation:
Custom tooltips show details only when needed, keeping the main report clean.

---

Question 5

How does filter context affect a custom tooltip?

A. Tooltips ignore all filters
B. Tooltips use only report-level filters
C. Tooltips inherit the visual’s filter context
D. Tooltips require manual filtering

Correct Answer: C. Tooltips inherit the visual’s filter context

Explanation:
Custom tooltips dynamically reflect the same context as the data point being hovered over.

---

Question 6

Which scenario is best suited for a custom tooltip rather than drillthrough?

A. Navigating to a detailed transaction report
B. Viewing additional KPIs when hovering over a chart
C. Analyzing data at a lower grain
D. Filtering another page

Correct Answer: B. Viewing additional KPIs when hovering over a chart

Explanation:
Custom tooltips are ideal for lightweight, hover-based insights, not deep exploration.

---

Question 7

What happens if a visual does not support report page tooltips?

A. The tooltip page still appears
B. Power BI shows an error
C. The default tooltip is used instead
D. The report fails to load

Correct Answer: C. The default tooltip is used instead

Explanation:
If a visual doesn’t support custom tooltips, Power BI falls back to the default tooltip behavior.

---

Question 8

Which best practice improves readability in custom tooltips?

A. Adding as many visuals as possible
B. Using small fonts to fit more data
C. Keeping the tooltip focused and concise
D. Disabling filter context

Correct Answer: C. Keeping the tooltip focused and concise

Explanation:
Tooltips are small by nature, so clarity and simplicity are critical.

---

Question 9

Which feature should you use if users need to click and explore data in depth rather than hover?

A. Custom tooltip
B. Bookmark
C. Drillthrough
D. Button

Correct Answer: C. Drillthrough

Explanation:
Drillthrough supports click-based navigation for deeper analysis, unlike hover-only tooltips.

---

Question 10

An exam question mentions “rich, context-aware insights displayed on hover without navigating away.” What feature is being described?

A. Drillthrough
B. Custom tooltip
C. Bookmark
D. Sync slicer

Correct Answer: B. Custom tooltip

Explanation:
This phrasing directly describes custom tooltips, a common exam cue.

---

Exam-Day Reminder

If the PL-300 question emphasizes:

• Hover-based interaction
• Context-aware insights
• Reducing report clutter
• Enhanced storytelling

👉 The correct answer is almost always Custom Tooltips.

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Edit and Configure Interactions Between Visuals

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

A report page contains a KPI card showing total revenue and several charts showing revenue by product and region. When a user selects a product, the KPI value changes, confusing executives.

What should you do?

A. Remove the product visual
B. Disable the interaction between the product visual and the KPI
C. Convert the KPI to a table
D. Apply a page-level filter

✅ Correct Answer: B

Explanation:
KPI visuals often represent overall performance and should remain constant. Disabling visual interactions prevents selections in other visuals from affecting the KPI. This directly addresses usability without altering the data model or filters.

---

Question 2

You want a column chart to emphasize selected categories while still showing the full distribution of values in the chart.

Which interaction type should you use?

A. Cross-filtering
B. No interaction
C. Cross-highlighting
D. Page-level filtering

✅ Correct Answer: C

Explanation:
Cross-highlighting keeps all data visible while visually emphasizing selected values. This is ideal when users need context while analyzing a subset of data.

---

Question 3

A table visual should not respond when users click on a slicer-like bar chart on the same page.

What is the best solution?

A. Remove the relationship between tables
B. Disable the interaction for the table visual
C. Use a different visual type
D. Add a report-level filter

✅ Correct Answer: B

Explanation:
Disabling the interaction ensures the table remains static, while preserving the data model and other interactions.

---

Question 4

Which scenario is the best candidate for disabling visual interactions?

A. A detail table showing drill-down data
B. A benchmark visual showing company targets
C. A bar chart comparing categories
D. A scatter plot used for exploration

✅ Correct Answer: B

Explanation:
Benchmark or target visuals often need to remain constant to provide context. Allowing them to change can mislead users.

---

Question 5

A user complains that selecting a value in one chart removes data from another chart, making comparisons difficult.

What should you change?

A. Switch from cross-filtering to cross-highlighting
B. Add a slicer
C. Duplicate the visual
D. Remove filters from the report

✅ Correct Answer: A

Explanation:
Cross-highlighting preserves context by showing all values, while still emphasizing the selected data.

---

Question 6

Visual interactions are configured at which level in Power BI?

A. Report level
B. Page level
C. Visual-to-visual level
D. Dataset level

✅ Correct Answer: C

Explanation:
Visual interactions define how one visual affects another visual on the same page.

---

Question 7

Which Power BI feature should you use if you want users to intentionally control filtering across multiple visuals?

A. Visual interactions
B. Row-level security
C. Slicers
D. Bookmarks

✅ Correct Answer: C

Explanation:
Slicers are designed for user-driven filtering, while visual interactions control passive responses between visuals.

---

Question 8

Which statement about visual interactions is true?

A. They apply across all report pages
B. They replace the need for filters
C. They can be disabled for specific visuals
D. They affect dataset security

✅ Correct Answer: C

Explanation:
Visual interactions are configurable per visual and apply only within the same report page.

---

Question 9

A report page includes explanatory text and instructions that should never change when users interact with charts.

What is the best approach?

A. Place the text on a separate page
B. Disable interactions for the text visual
C. Use bookmarks
D. Apply a report-level filter

✅ Correct Answer: B

Explanation:
Disabling interactions ensures static elements remain unchanged, improving clarity and usability.

---

Question 10

You are designing a report for executives. Which practice improves storytelling and clarity?

A. Allow all visuals to interact by default
B. Disable unnecessary interactions
C. Replace charts with tables
D. Use only slicers for filtering

✅ Correct Answer: B

Explanation:
Intentional interaction design reduces confusion and guides users toward meaningful insights.

---

Exam Takeaway

If a question describes:

• Confusing visual behavior
• Unexpected filtering
• KPIs or benchmarks changing
• Loss of context

➡ Configuring visual interactions is very often the correct solution.

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure navigation for a report

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

You want users to navigate between report pages using clearly labeled buttons instead of page tabs. Which feature should you use?

A. Drill-through
B. Bookmarks
C. Page navigation buttons
D. Slicers

Correct Answer: C

Explanation:
Page navigation buttons allow users to move between report pages using clickable buttons. This is a common technique for creating guided or executive-style reports and is frequently tested on the PL-300 exam.

---

Question 2

You need to show and hide a group of visuals on a page when a user clicks a button. Which feature should you configure?

A. Drill-through
B. Filters
C. Visual interactions
D. Bookmarks

Correct Answer: D

Explanation:
Bookmarks capture the visibility state of visuals. By assigning a bookmark to a button, users can toggle visuals on or off, making bookmarks essential for interactive navigation scenarios.

---

Question 3

A report allows users to right-click a bar in a chart and navigate to a detail page that preserves the selected category. What navigation method is being used?

A. Page navigation
B. Bookmark navigation
C. Drill-through
D. Page navigator

Correct Answer: C

Explanation:
Drill-through enables navigation to another page while passing filter context automatically. This is ideal for moving from summary views to detailed analysis.

---

Question 4

You want a navigation menu that automatically updates when new report pages are added. Which visual should you use?

A. Button
B. Bookmark navigator
C. Page navigator
D. Slicer

Correct Answer: C

Explanation:
The Page Navigator visual dynamically reflects report pages and updates automatically when pages are added or removed, reducing manual maintenance.

---

Question 5

Which scenario is the best use case for hiding a report page?

A. Improving dataset refresh speed
B. Preventing users from exporting data
C. Using the page only as a drill-through target
D. Applying row-level security

Correct Answer: C

Explanation:
Hidden pages are commonly used for drill-through or bookmark destinations. They remain accessible through navigation but do not appear as visible tabs.

---

Question 6

A report designer wants users to switch between “Summary” and “Detail” views on the same page without navigating to another page. What is the best solution?

A. Drill-through
B. Bookmarks with buttons
C. Page navigation buttons
D. Filters pane

Correct Answer: B

Explanation:
Bookmarks can store different visual states on the same page. Buttons assigned to bookmarks allow users to toggle between views seamlessly.

---

Question 7

Which navigation method allows users to navigate without preserving filter context?

A. Drill-through
B. Page navigation
C. Tooltip navigation
D. Cross-filtering

Correct Answer: B

Explanation:
Page navigation simply moves users between pages and does not automatically preserve filter context, unlike drill-through.

---

Question 8

You want to create an app-like experience where users navigate through a predefined story flow. Which combination is most appropriate?

A. Slicers and filters
B. Drill-through only
C. Buttons and bookmarks
D. Tooltips and KPIs

Correct Answer: C

Explanation:
Buttons combined with bookmarks provide full control over navigation flow and visual state, making them ideal for storytelling and guided experiences.

---

Question 9

Which feature allows navigation between different visual states rather than different pages?

A. Page navigator
B. Drill-through
C. Bookmark navigator
D. Page tabs

Correct Answer: C

Explanation:
The Bookmark Navigator visual allows users to navigate between bookmarks, making it ideal for single-page, multi-view report designs.

---

Question 10

An executive report should prevent users from freely navigating pages and instead guide them through insights step by step. What should you do?

A. Enable visual interactions
B. Hide page tabs and use buttons for navigation
C. Add more slicers
D. Use drill-through on every visual

Correct Answer: B

Explanation:
Hiding page tabs and using navigation buttons ensures a controlled, guided experience—commonly recommended for executive dashboards and tested on PL-300.

---

Quick Exam Summary

For PL-300, remember:

• Buttons = controlled page navigation
• Bookmarks = show/hide content & state management
• Drill-through = context-aware detail navigation
• Navigators = dynamic menus
• Hidden pages = drill-through & support pages

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Apply sorting to visuals

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

You have a bar chart showing Sales by Product Name. The bars are currently sorted alphabetically. You want to rank products from highest to lowest sales. What should you do?

A. Create a calculated column for sales
B. Use Sort by Column on Product Name
C. Sort the visual by the Sales measure
D. Apply a Top N filter

Correct Answer: C

Explanation:
Visual-level sorting allows you to sort by any field in the visual, including measures. Sorting by the Sales measure ranks products correctly by performance.

---

Question 2

Month names in a report appear alphabetically instead of January through December. What is the best solution?

A. Sort the visual by Month Name descending
B. Create a Month Number column and use Sort by Column
C. Sort by a measure
D. Use a Top N filter

Correct Answer: B

Explanation:
The Sort by Column feature enforces a logical order using a supporting column (Month Number). This ensures correct ordering across all visuals.

---

Question 3

Which statement about Sort by Column is true?

A. It only applies to the current visual
B. It can sort by a measure
C. It applies globally wherever the column is used
D. It works only in Power BI Service

Correct Answer: C

Explanation:
Sort by Column is a model-level setting. Once applied, all visuals using that column follow the defined sort order.

---

Question 4

You want a table visual to dynamically reorder rows based on slicer selections. Which sorting method supports this?

A. Alphabetical sorting
B. Sort by a static column
C. Sort by a measure
D. Manual row ordering

Correct Answer: C

Explanation:
Sorting by a measure is evaluated in the current filter context, meaning slicers and filters dynamically affect the order.

---

Question 5

Which visual does not support sorting?

A. Bar chart
B. Table
C. Matrix
D. Card

Correct Answer: D

Explanation:
Card visuals display a single value and therefore do not support sorting.

---

Question 6

A column chart is sorted by a measure, but the order changes when slicers are applied. Why does this happen?

A. The visual is incorrectly configured
B. Measures are recalculated per filter context
C. Sorting resets when slicers are used
D. Power BI does not support dynamic sorting

Correct Answer: B

Explanation:
Measures are evaluated within the current filter context, so applying slicers recalculates values and changes the sort order.

---

Question 7

You attempt to use Sort by Column, but Power BI displays an error. What is the most likely cause?

A. The sorting column contains text values
B. There is not a one-to-one mapping between columns
C. The column is hidden
D. The visual is already sorted

Correct Answer: B

Explanation:
Sort by Column requires a one-to-one relationship. Duplicate or ambiguous values cause Power BI to block the configuration.

---

Question 8

You apply a Top 10 filter to a visual but do not change the sorting. What is the likely result?

A. Items appear sorted by value automatically
B. Items appear alphabetically
C. Items appear randomly
D. Sorting is disabled

Correct Answer: B

Explanation:
Top N filtering does not automatically sort visuals. Without explicit sorting, Power BI often defaults to alphabetical order.

---

Question 9

Which approach ensures weekday names always appear Monday through Sunday across all visuals?

A. Sort visuals manually
B. Sort by a measure
C. Use Sort by Column with a weekday number
D. Apply a Top N filter

Correct Answer: C

Explanation:
Model-level sorting using a supporting numeric column ensures consistent ordering across all visuals.

---

Question 10

When sorting a matrix visual, which statement is true?

A. Multiple columns can control sorting simultaneously
B. Sorting is fixed and cannot be changed
C. Only one column controls the sort order at a time
D. Sorting is unavailable in matrix visuals

Correct Answer: C

Explanation:
Matrix visuals allow sorting by one column at a time, typically through header interactions.

---

Quick Exam Recap

Remember for PL-300:

• Visual-level sorting → report-specific
• Sort by Column → model-wide
• Measures sort dynamically
• Top N ≠ automatic sorting
• One-to-one mapping is required

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure sync slicers

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

You want a Date slicer to filter multiple report pages while remaining visible only on the first page. What should you configure?

A. Page-level filters
B. Report-level filters
C. Sync slicers with visibility turned off on other pages
D. Visual interactions

Correct Answer: C

Explanation:
Sync slicers allow selections to be shared across pages, while the Visible option controls whether the slicer appears on each page.

---

Question 2

Where do you configure slicer synchronization in Power BI Desktop?

A. Format pane
B. Filters pane
C. Model view
D. Sync slicers pane

Correct Answer: D

Explanation:
Slicer syncing is configured using the Sync slicers pane, which is accessed from the View tab.

---

Question 3

Which statement about sync slicers is true?

A. They apply filters across different reports
B. They only work with date fields
C. They sync slicer selections across selected pages
D. They replace report-level filters

Correct Answer: C

Explanation:
Sync slicers share the selection state of a slicer across chosen pages within the same report.

---

Question 4

A slicer is synced to a page but not visible. What happens?

A. The page is not filtered
B. The slicer is ignored
C. The slicer filters the page without being displayed
D. Power BI shows an error

Correct Answer: C

Explanation:
Visibility and synchronization are separate settings. A slicer can still filter a page even when hidden.

---

Question 5

Which scenario is the best use case for sync slicers?

A. Sorting visuals by a measure
B. Creating drill-through pages
C. Maintaining consistent filters across report pages
D. Applying row-level security

Correct Answer: C

Explanation:
Sync slicers are designed to maintain consistent user-selected filters as users navigate between pages.

---

Question 6

Which of the following cannot be achieved using sync slicers?

A. Sharing slicer selections across pages
B. Hiding slicers on specific pages
C. Filtering individual visuals only
D. Preserving filter context during navigation

Correct Answer: C

Explanation:
Sync slicers operate at the page level, not at the individual visual level.

---

Question 7

Two slicers use the same field but are not syncing. What is the most likely cause?

A. The slicers are hidden
B. The slicers are on different pages
C. Sync has not been enabled
D. The field contains duplicate values

Correct Answer: C

Explanation:
Slicers do not sync automatically. Sync must be explicitly enabled in the Sync slicers pane.

---

Question 8

Which filtering option is most appropriate when you want a filter applied to all pages but not controlled by users?

A. Visual-level filter
B. Page-level filter
C. Report-level filter
D. Sync slicer

Correct Answer: C

Explanation:
Report-level filters apply to all pages without user interaction, unlike sync slicers which are user-driven.

---

Question 9

What happens if a synced slicer selection conflicts with a page-level filter?

A. The slicer overrides the page filter
B. The page filter overrides the slicer
C. Both filters are applied together
D. The slicer is disabled

Correct Answer: C

Explanation:
Power BI combines filters using AND logic, so both slicer and page-level filters affect the result.

---

Question 10

Which of the following is a common PL-300 exam pitfall related to sync slicers?

A. Expecting them to work across reports
B. Assuming they only apply to tables
C. Thinking they automatically sync
D. Believing they only work on visible slicers

Correct Answer: A

Explanation:
Sync slicers only work within a single report. They cannot synchronize slicers across multiple reports.

---

Quick Exam Recap

For PL-300, remember:

• Sync slicers maintain filter consistency across pages
• Sync and Visible are separate settings
• Hidden slicers still filter data
• Sync slicers are user-controlled
• They work only within one report

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure Drill-Through Navigation

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

What is the primary purpose of drill-through navigation in Power BI?

A. To filter visuals within the same report page
B. To navigate to another report while preserving filters
C. To navigate to another report page while passing filter context
D. To display detailed data in a tooltip

✅ Correct Answer: C

Explanation:
Drill-through allows users to navigate between pages in the same report while automatically passing filter context based on the selected data point.

---

Question 2

Where must a field be placed to enable drill-through functionality?

A. Visual-level filters
B. Page-level filters
C. Drill-through filters section
D. Report-level filters

✅ Correct Answer: C

Explanation:
A page becomes a drill-through target only when one or more fields are added to the Drill-through filters section of the Filters pane.

---

Question 3

Which condition must be met for a visual to support drill-through to a target page?

A. The visual must be a table or matrix
B. The visual must contain the same field as the drill-through filter
C. The visual must be on the same page
D. The visual must contain all report filters

✅ Correct Answer: B

Explanation:
A visual can initiate drill-through only if it contains at least one field that matches a field defined in the drill-through filters of the target page.

---

Question 4

A user right-clicks a data point but does not see the Drill-through option. What is the most likely cause?

A. Drill-through is disabled in Power BI Desktop
B. No drill-through fields were configured on the target page
C. The report has too many visuals
D. The page contains a Back button

✅ Correct Answer: B

Explanation:
If no fields are added to the Drill-through filters on a page, Power BI will not expose that page as a drill-through option.

---

Question 5

What is the purpose of the Back button on a drill-through page?

A. Clears all filters
B. Returns users to the home page
C. Navigates back while preserving filter context
D. Refreshes visuals

✅ Correct Answer: C

Explanation:
The Back button returns users to the source page and retains the original filter context, making it essential for usability and navigation.

---

Question 6

What happens when the Keep all filters option is enabled on a drill-through button?

A. Only drill-through filters are applied
B. Page-level filters are removed
C. All active filters and slicers are passed to the target page
D. Filters are ignored

✅ Correct Answer: C

Explanation:
When enabled, Keep all filters ensures that all filter context, including slicers and page-level filters, is passed during drill-through.

---

Question 7

Which visual type does NOT support drill-through as a source visual?

A. Bar chart
B. Table
C. Matrix
D. Card

✅ Correct Answer: D

Explanation:
Card visuals do not contain categorical context and therefore cannot initiate drill-through.

---

Question 8

Which statement best describes the relationship between drill-through and page navigation?

A. They serve the same purpose
B. Drill-through replaces bookmarks
C. Page navigation passes filter context automatically
D. Drill-through passes filter context; page navigation does not

✅ Correct Answer: D

Explanation:
Drill-through uniquely passes filter context automatically, while page navigation simply moves between pages without context.

---

Question 9

Can drill-through be configured to pass multiple fields?

A. No, only one field is supported
B. Yes, but only from table visuals
C. Yes, by adding multiple fields to drill-through filters
D. Yes, but only with DAX

✅ Correct Answer: C

Explanation:
Multiple fields can be added to the Drill-through filters section, allowing for compound filtering on the target page.

---

Question 10

Which scenario is the best use case for drill-through navigation?

A. Showing explanatory text
B. Switching between report themes
C. Moving from a summary KPI to transaction-level details
D. Applying conditional formatting

✅ Correct Answer: C

Explanation:
Drill-through is designed to move from high-level summaries to detailed supporting data, making it ideal for analytical storytelling.

---

PL-300 Exam Tips for Drill-Through

• Know where drill-through filters live
• Understand filter context passing
• Recognize supported and unsupported visuals
• Expect scenario-based questions
• Always think: “How does the user get more detail?”

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure Export Settings

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

A user exports data from a table visual and receives only aggregated values instead of individual rows. What is the most likely reason?

A. Row-Level Security is filtering the data
B. The visual is using a calculated column
C. Export of underlying data is disabled
D. The dataset is using DirectQuery

Correct Answer: C

Explanation:
When underlying data export is disabled, Power BI allows only summarized data to be exported. This is commonly used to prevent access to row-level data.

---

Question 2

Which export option preserves visual formatting but removes interactivity?

A. Export data to Excel
B. Export summarized data
C. Export as PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
Exporting to PDF preserves layout and formatting but results in a static, non-interactive file.

---

Question 3

A report author disables export options for a visual, but users can still export data in the Power BI Service. What is the most likely cause?

A. Dataset permissions override visual settings
B. Row-Level Security is disabled
C. Visual interactions are enabled
D. The report is using Import mode

Correct Answer: A

Explanation:
Dataset and tenant-level settings can override visual-level restrictions, allowing exports even if a visual is configured to restrict them.

---

Question 4

Which export behavior always respects Row-Level Security (RLS)?

A. Export summarized data
B. Export underlying data
C. Export to Excel
D. All export methods

Correct Answer: D

Explanation:
All export methods in Power BI respect RLS, ensuring users only export data they are authorized to see.

---

Question 5

An organization wants to prevent users from exporting row-level data across all reports. Where should this be configured?

A. Visual formatting pane
B. Report settings in Power BI Desktop
C. Dataset settings in Power BI Service
D. Power BI Admin portal

Correct Answer: D

Explanation:
The Power BI Admin portal allows administrators to enforce export restrictions tenant-wide, overriding report and dataset settings.

---

Question 6

Which export option allows users to include current slicer and filter selections?

A. Export summarized data
B. Export report to PDF
C. Export underlying data
D. Copy visual as image

Correct Answer: B

Explanation:
When exporting a report to PDF, users can choose to export with current values, which includes applied filters and slicers.

---

Question 7

A user wants to export data for further analysis while keeping the original Power BI dataset connected. Which option should they use?

A. Export underlying data
B. Export summarized data
C. Analyze in Excel
D. Export to PowerPoint

Correct Answer: C

Explanation:
Analyze in Excel maintains a live connection to the Power BI dataset, enabling dynamic analysis without extracting the data.

---

Question 8

What happens if underlying data export is disabled but summarized data export is enabled?

A. Users cannot export data
B. Users can export aggregated values only
C. Users can export only visuals
D. Users can export row-level data

Correct Answer: B

Explanation:
With underlying data disabled, Power BI allows exports of aggregated values only, matching what is displayed in the visual.

---

Question 9

Which export format is best suited for executive summaries and board-level reporting?

A. Excel (.xlsx)
B. CSV
C. PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
PDF exports are ideal for executive reporting because they preserve formatting and are easy to distribute and consume.

---

Question 10

A report uses sensitivity labels that restrict data sharing. What impact do these labels have on exports?

A. They remove all export options
B. They allow exports but remove filters
C. They may restrict or block exports based on policy
D. They only affect sharing, not exporting

Correct Answer: C

Explanation:
Sensitivity labels can enforce data protection rules, including restricting or disabling export options depending on organizational policies.

---

Final Exam Tip

For PL-300, always think in this order when troubleshooting exports:

Tenant → Dataset → Report → Visual

The most restrictive setting wins, and security is never bypassed.

---

Go back to the PL-300 Exam Prep Hub main page

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Design Reports for Mobile Devices

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

You publish a Power BI report that was designed only using the standard report canvas. A user views the report in the Power BI mobile app. What happens?

A. The report cannot be opened
B. The report automatically switches to a paginated view
C. The desktop layout is shown, scaled to fit the screen
D. The mobile layout is generated automatically

Correct Answer: C

Explanation:
If no mobile layout is defined, Power BI displays the desktop layout scaled to fit the mobile screen, which often leads to poor usability.

---

Question 2

Which Power BI feature allows you to create a phone-optimized layout for a report page?

A. Bookmarks
B. Focus mode
C. Mobile layout view
D. Selection pane

Correct Answer: C

Explanation:
The Mobile layout view in Power BI Desktop lets you design a separate layout specifically optimized for mobile devices.

---

Question 3

Which of the following is true about visuals in a mobile layout?

A. All desktop visuals automatically appear
B. Only selected visuals appear
C. Visuals appear but cannot be resized
D. Mobile layouts only support cards and charts

Correct Answer: B

Explanation:
Only visuals that you explicitly add to the mobile layout will appear in the Power BI mobile app.

---

Question 4

What is the recommended layout pattern for mobile report pages?

A. Multi-column grids
B. Side-by-side visuals
C. Freeform overlapping visuals
D. Single-column vertical scrolling

Correct Answer: D

Explanation:
Mobile reports should use single-column, vertically stacked visuals to support natural scrolling and readability.

---

Question 5

Which visual type is generally least suitable for mobile report layouts?

A. KPI card
B. Line chart
C. Large matrix with many columns
D. Bar chart

Correct Answer: C

Explanation:
Large matrices with many columns are difficult to read and interact with on small mobile screens.

---

Question 6

A report consumer needs to interact with slicers on a mobile device. What is the best design approach?

A. Add as many slicers as possible
B. Use dropdown slicers and limit their number
C. Place slicers at the bottom of the page
D. Disable slicers for mobile layouts

Correct Answer: B

Explanation:
Dropdown slicers save space and improve usability on small screens. Limiting the number of slicers is a best practice.

---

Question 7

Which of the following actions can help improve performance of mobile reports?

A. Adding more visuals
B. Increasing visual interactivity
C. Reducing the number of visuals per page
D. Using larger images

Correct Answer: C

Explanation:
Mobile devices have limited resources. Reducing the number of visuals improves performance and load times.

---

Question 8

How does Power BI handle drill-through functionality on mobile devices?

A. Drill-through is not supported
B. Drill-through works only in landscape mode
C. Drill-through works but must be clearly designed
D. Drill-through only works on paginated reports

Correct Answer: C

Explanation:
Drill-through works on mobile, but users must be able to clearly identify how to access it, often through large touch-friendly visuals.

---

Question 9

When should you create a mobile layout instead of relying on the desktop layout?

A. Only when using paginated reports
B. When users will primarily view reports on phones
C. Only when using DirectQuery
D. When exporting to PowerPoint

Correct Answer: B

Explanation:
If report consumption is primarily on mobile devices, creating a dedicated mobile layout is strongly recommended.

---

Question 10

Which of the following statements about mobile layouts is correct?

A. Mobile layouts replace desktop layouts
B. Mobile layouts must be created before publishing
C. Each report page can have its own mobile layout
D. Mobile layouts only work in Power BI Desktop

Correct Answer: C

Explanation:
Each report page can have its own mobile-specific layout, independent of other pages.

---

Exam Readiness Tip

For PL-300 questions mentioning:

• Phones
• Power BI mobile app
• Executives on the go
• Small screens

👉 Think mobile layout, simplified visuals, and touch-friendly design.

---

Go back to the PL-300 Exam Prep Hub main page