Category: PL-300

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Apply conditional formatting (PL-300 Exam Prep)

 
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
      --> Apply conditional formatting

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 table visual should highlight negative profit values in red and positive values in green.
Which conditional formatting option is the most appropriate?

A. Data bars
B. Color scale
C. Rules
D. Field value

Correct Answer: C

Explanation:
Rules allow you to define explicit conditions (e.g., value < 0 = red, value ≥ 0 = green), making them ideal for positive/negative logic.

Question 2

You want to show the relative magnitude of sales directly inside a table column using horizontal bars.
Which conditional formatting type should you use?

A. Background color
B. Icons
C. Data bars
D. Font color

Correct Answer: C

Explanation:
Data bars display values as horizontal bars within table or matrix cells, making it easy to compare magnitude at a glance.

Question 3

A report requires gradual color shading from light to dark based on performance values.
Which conditional formatting option supports this requirement?

A. Rules
B. Color scale
C. Icons
D. Field value

Correct Answer: B

Explanation:
Color scales use gradients to represent a range of values, ideal for showing relative differences across data points.

Question 4

Conditional formatting should be applied to a table column based on a measure rather than the displayed field.
Which option allows this behavior?

A. Rules
B. Color scale
C. Field value
D. Data bars

Correct Answer: C

Explanation:
Field value formatting lets you base formatting on a separate measure, enabling advanced and dynamic formatting scenarios.

Question 5

Which visual type supports conditional formatting most extensively in Power BI?

A. Pie chart
B. Line chart
C. Table
D. Slicer

Correct Answer: C

Explanation:
Tables (and matrices) support the widest range of conditional formatting options, including background colors, font colors, data bars, and icons.

Question 6

A business user wants values above a fixed target to appear green and values below the target to appear red.
What is the best approach?

A. Use a color scale
B. Apply data bars
C. Use rules with thresholds
D. Change the theme

Correct Answer: C

Explanation:
Rules allow you to define precise thresholds, making them the best choice when formatting must follow specific business targets.

Question 7

Which scenario is least appropriate for using conditional formatting?

A. Highlighting underperforming regions
B. Emphasizing high and low values
C. Creating calculated columns
D. Showing trends in tables

Correct Answer: C

Explanation:
Conditional formatting is for visual emphasis, not data modeling or calculations, which are handled with DAX or Power Query.

Question 8

Why should conditional formatting be used sparingly in reports?

A. It slows down data refresh
B. It increases dataset size
C. Too much formatting reduces clarity
D. It disables cross-filtering

Correct Answer: C

Explanation:
Overusing conditional formatting can overwhelm users and obscure insights rather than clarify them.

Question 9

A matrix visual uses conditional formatting, but totals are not formatted as expected.
What should you check first?

A. Data model relationships
B. Visual interactions
C. Conditional formatting settings for totals
D. Report theme

Correct Answer: C

Explanation:
Conditional formatting for totals can be configured separately, and defaults may differ from row-level formatting.

Question 10

What is the primary purpose of conditional formatting in Power BI reports?

A. Improve query performance
B. Replace visual interactions
C. Enhance data interpretation
D. Secure sensitive data

Correct Answer: C

Explanation:
Conditional formatting improves how users interpret data by visually emphasizing important values, patterns, and exceptions.

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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Apply Slicing and Filtering (PL-300 Exam Prep)

 
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
      --> Apply Slicing and Filtering

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 multiple visuals. Only one chart should be filtered to show data for the “West” region.
Which filtering approach should you use?

A. Report-level filter
B. Page-level filter
C. Visual-level filter
D. Slicer

Correct Answer: C

Explanation:
Visual-level filters affect only the selected visual, making them ideal when filtering should not impact other visuals on the page.

Question 2

You want users to interactively filter report visuals by selecting values from a dropdown on the report canvas.
Which feature should you use?

A. Page-level filter
B. Visual-level filter
C. Slicer
D. Drillthrough

Correct Answer: C

Explanation:
Slicers are visible, interactive controls that allow users to filter visuals dynamically.

Question 3

A filter must apply to all visuals on every page in the report.
Which filter scope should be used?

A. Visual-level
B. Page-level
C. Report-level
D. Drillthrough

Correct Answer: C

Explanation:
Report-level filters apply across the entire report, affecting all pages and visuals.

Question 4

Users should be able to right-click a value in a visual and navigate to a detail page that shows related information.
Which feature enables this?

A. Page-level filter
B. Cross-highlighting
C. Drillthrough
D. Slicer

Correct Answer: C

Explanation:
Drillthrough filters pass the selected context to another report page, enabling detailed analysis.

Question 5

A date slicer should always show dynamic options such as “Last 7 days” or “Last 30 days.”
Which filtering type supports this requirement?

A. Basic filtering
B. Relative date filtering
C. Advanced filtering
D. Top N filtering

Correct Answer: B

Explanation:
Relative date filtering allows time-based filtering that updates automatically as time passes.

Question 6

A bar chart should display only the top 5 products by revenue.
Which filter type should you use?

A. Basic filter
B. Relative date filter
C. Advanced filter
D. Top N filter

Correct Answer: D

Explanation:
Top N filtering limits displayed values based on a measure, such as revenue.

Question 7

A slicer is added to a report page, but one visual should ignore its selection.
What should you configure?

A. Visual-level filter
B. Edit interactions
C. Report-level filter
D. Drillthrough field

Correct Answer: B

Explanation:
Edit interactions allows you to control how slicers affect individual visuals, including disabling interactions.

Question 8

Which scenario is best suited for using a slicer rather than a filter pane?

A. Applying a fixed filter that users should not change
B. Hiding irrelevant data across the entire report
C. Allowing users to explore different categories dynamically
D. Enforcing security rules

Correct Answer: C

Explanation:
Slicers are designed for user-driven, interactive exploration of data.

Question 9

Clicking a data point in one visual highlights related values in another visual without removing unrelated data.
What is this behavior called?

A. Cross-filtering
B. Drillthrough
C. Cross-highlighting
D. Basic filtering

Correct Answer: C

Explanation:
Cross-highlighting emphasizes related data points while keeping the full dataset visible.

Question 10

Which best describes the primary purpose of slicing and filtering in Power BI?

A. Improve data refresh speed
B. Restrict data at the source
C. Enable interactive data exploration
D. Create calculated fields

Correct Answer: C

Explanation:
Slicing and filtering allow users to explore subsets of data interactively, improving insight and usability.

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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Use Copilot to Create a New Report Page (PL-300 Exam Prep)

 
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
      --> Use Copilot to Create a New Report Page

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 author wants to quickly generate a new page with visuals based on a natural language request.
Which feature should they use?

A. Quick measures
B. Smart narratives
C. Copilot
D. Analyze feature

Correct Answer: C

Explanation:
Copilot allows users to create report content, including new pages and visuals, using natural language prompts.

Question 2

What is the primary purpose of using Copilot to create a new report page?

A. Replace manual report development
B. Automatically validate business logic
C. Accelerate report creation
D. Optimize data model performance

Correct Answer: C

Explanation:
Copilot is designed to speed up report creation by generating a starting point, not to replace analyst validation or optimization.

Question 3

Which prerequisite must be met to use Copilot in Power BI?

A. The dataset must use DirectQuery
B. The tenant must have Copilot enabled
C. The report must be published
D. The model must use calculated columns

Correct Answer: B

Explanation:
Copilot requires tenant-level enablement and appropriate licensing before it can be used in Power BI.

Question 4

After Copilot generates a new report page, what should the analyst do next?

A. Publish the report immediately
B. Refresh the dataset
C. Review and refine the generated visuals
D. Apply row-level security

Correct Answer: C

Explanation:
Copilot output must always be reviewed and refined to ensure accuracy, relevance, and alignment with business requirements.

Question 5

Which factor most directly affects the quality of Copilot-generated report pages?

A. Report theme selection
B. Data model clarity and design
C. Number of visuals in the report
D. Dataset size

Correct Answer: B

Explanation:
Copilot relies on the semantic model. Clear naming, relationships, and measures significantly improve output quality.

Question 6

Which task is least appropriate for Copilot when creating a report page?

A. Adding commonly used visuals
B. Selecting measures based on model metadata
C. Defining complex business logic
D. Creating an initial layout

Correct Answer: C

Explanation:
Copilot does not understand nuanced business rules and should not be relied on to define complex logic or calculations.

Question 7

A user wants a new report page that summarizes sales trends without manually selecting visuals.
Which benefit of Copilot does this demonstrate?

A. Data security enforcement
B. Automatic performance tuning
C. AI-assisted report scaffolding
D. Relationship optimization

Correct Answer: C

Explanation:
Copilot excels at quickly scaffolding report pages by generating visuals and layouts from natural language requests.

Question 8

Which statement about Copilot-generated report pages is true?

A. They are always production-ready
B. They cannot be edited manually
C. They serve as a starting point for refinement
D. They replace the need for report designers

Correct Answer: C

Explanation:
Copilot-generated pages are intended as a draft that analysts refine, format, and validate.

Question 9

When is Copilot the best choice for creating a new report page?

A. When precise formatting is required
B. When business logic is highly complex
C. When speed and rapid prototyping are priorities
D. When dataset security must be enforced

Correct Answer: C

Explanation:
Copilot is most effective when rapid page creation is needed and detailed refinement can follow.

Question 10

Why does the PL-300 exam include Copilot-related topics?

A. To test AI model training skills
B. To emphasize modern Power BI authoring capabilities
C. To replace traditional report design questions
D. To reduce the need for DAX knowledge

Correct Answer: B

Explanation:
Microsoft includes Copilot topics to ensure analysts understand how AI-assisted tools fit into modern report development workflows.

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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Use Copilot to Suggest Content for a New Report Page (PL-300 Exam Prep)

 
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
      --> Use Copilot to Suggest Content for a New Report Page

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 author wants guidance on which visuals and measures to include on a new report page but does not want the page built automatically.
Which feature should they use?

A. Smart narratives
B. Analyze feature
C. Copilot
D. Quick measures

Correct Answer: C

Explanation:
Copilot can suggest relevant visuals and content without automatically creating a finished report page.

Question 2

What is the primary role of Copilot when suggesting content for a new report page?

A. Enforcing security rules
B. Providing design and analysis recommendations
C. Writing DAX expressions
D. Optimizing dataset performance

Correct Answer: B

Explanation:
Copilot acts as an AI assistant that recommends visuals, fields, and analytical focus areas based on the data model.

Question 3

Which factor most directly impacts the quality of Copilot’s content suggestions?

A. Report theme
B. Visual interactions
C. Semantic model design
D. Dataset refresh frequency

Correct Answer: C

Explanation:
Copilot relies on table names, relationships, and measures in the semantic model to generate meaningful suggestions.

Question 4

Which statement about Copilot content suggestions is true?

A. Suggestions are always business-validated
B. Suggestions replace analyst judgment
C. Suggestions are optional and advisory
D. Suggestions cannot be edited

Correct Answer: C

Explanation:
Copilot suggestions are guidance only and must be reviewed and curated by the analyst.

Question 5

When is Copilot most appropriate for suggesting content for a new report page?

A. When complex business rules must be defined
B. When final report formatting is required
C. When exploring what insights the data can provide
D. When applying row-level security

Correct Answer: C

Explanation:
Copilot excels during the ideation phase, helping analysts explore potential insights and visual approaches.

Question 6

Which task should not be expected from Copilot when suggesting report content?

A. Recommending common visual types
B. Identifying relevant measures
C. Validating KPI definitions
D. Highlighting trends and comparisons

Correct Answer: C

Explanation:
Copilot does not validate business logic or KPI definitions; that responsibility remains with the analyst.

Question 7

How does using Copilot to suggest content benefit report development?

A. It removes the need for manual design
B. It ensures perfect visual layouts
C. It accelerates the report planning process
D. It replaces dataset modeling

Correct Answer: C

Explanation:
Copilot speeds up early-stage report planning by offering quick, AI-generated ideas for content.

Question 8

A user wants recommendations for KPIs and breakdowns before deciding which visuals to add.
Which Copilot capability does this scenario demonstrate?

A. Automated storytelling
B. AI-assisted ideation
C. Performance optimization
D. Data modeling automation

Correct Answer: B

Explanation:
Copilot’s content suggestions support ideation by helping users decide what information to present.

Question 9

Which best describes the relationship between Copilot suggestions and manual report creation?

A. Copilot replaces manual creation
B. Copilot output cannot be modified
C. Copilot provides guidance that analysts refine
D. Copilot only works after publishing

Correct Answer: C

Explanation:
Copilot offers recommendations that analysts evaluate, refine, and implement manually.

Question 10

Why does the PL-300 exam include questions about Copilot suggesting content?

A. To test AI model training skills
B. To emphasize modern, AI-assisted reporting workflows
C. To reduce focus on visual design
D. To eliminate manual report development

Correct Answer: B

Explanation:
Microsoft includes Copilot topics to reflect the evolving role of AI in Power BI while reinforcing the analyst’s responsibility.

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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Choose When to Use a Paginated Report (PL-300 Exam Prep)

 
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
      --> Choose When to Use a Paginated 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

A finance team needs a report that will be exported to PDF and printed monthly. Each page must have consistent headers, footers, and margins. Which reporting option should you recommend?

A. Power BI dashboard
B. Power BI report in Desktop
C. Paginated report
D. Excel report connected to a dataset

Correct Answer: C. Paginated report

Explanation:
Paginated reports are designed for pixel-perfect, print-ready output with full control over page layout, headers, and footers.

Question 2

A report contains tens of thousands of transaction rows that must be displayed across multiple pages without truncation. Which report type is most appropriate?

A. Power BI interactive report
B. Paginated report
C. Dashboard tile
D. KPI visual

Correct Answer: B. Paginated report

Explanation:
Paginated reports automatically flow large tables across pages, making them ideal for high-row-count, detail-heavy reports.

Question 3

Which scenario best indicates the need for a paginated report instead of a Power BI report?

A. Users want to explore trends interactively
B. Users want cross-filtering between visuals
C. Users need a fixed-layout report for regulatory compliance
D. Users want real-time dashboard updates

Correct Answer: C. Users need a fixed-layout report for regulatory compliance

Explanation:
Regulatory and compliance reports often require precise formatting and consistent layout, which paginated reports provide.

Question 4

Which tool is used to create paginated reports in the Power BI ecosystem?

A. Power BI Desktop
B. Power BI Service
C. Power BI Report Builder
D. Microsoft Excel

Correct Answer: C. Power BI Report Builder

Explanation:
Paginated reports are created using Power BI Report Builder, a separate tool from Power BI Desktop.

Question 5

A manager requests a report that users can slice, filter, and drill into interactively during meetings. Should you use a paginated report?

A. Yes, paginated reports support advanced interactivity
B. Yes, paginated reports optimize performance
C. No, a Power BI interactive report is better
D. No, dashboards are required

Correct Answer: C. No, a Power BI interactive report is better

Explanation:
Paginated reports are not designed for rich interactivity. Power BI reports are better suited for exploration and analysis.

Question 6

Which feature is a key advantage of paginated reports over Power BI reports?

A. Cross-highlighting
B. Drill-down visuals
C. Pixel-perfect page layout
D. Real-time streaming data

Correct Answer: C. Pixel-perfect page layout

Explanation:
The defining advantage of paginated reports is precise control over layout, especially for printing and exporting.

Question 7

A company wants to reuse an existing Power BI dataset to generate formatted invoices. Which reporting option supports this requirement?

A. Dashboard
B. Power BI report
C. Paginated report
D. Excel pivot table

Correct Answer: C. Paginated report

Explanation:
Paginated reports can connect directly to Power BI semantic models (datasets) and generate formatted outputs like invoices.

Question 8

Which licensing consideration applies to paginated reports in Power BI?

A. Available with any free Power BI license
B. Requires Power BI Pro only
C. Requires Power BI Premium or Premium Per User
D. Requires Excel licensing

Correct Answer: C. Requires Power BI Premium or Premium Per User

Explanation:
Paginated reports require Premium capacity or Premium Per User for publishing and sharing.

Question 9

Which of the following is NOT a good use case for a paginated report?

A. Employee payroll statements
B. Monthly financial summaries for printing
C. Interactive executive dashboards
D. Transaction-level audit reports

Correct Answer: C. Interactive executive dashboards

Explanation:
Interactive dashboards rely on dynamic visuals and user-driven exploration, which are not strengths of paginated reports.

Question 10

A question on the PL-300 exam describes a report that must look identical every time it is exported, regardless of screen size. What should this indicate?

A. Use a dashboard
B. Use a Power BI report
C. Use a paginated report
D. Use a mobile layout

Correct Answer: C. Use a paginated report

Explanation:
Paginated reports ensure consistent output independent of screen size, making them ideal for exports and printing.

Exam-Day Reminder

If the scenario emphasizes:

  • Printing
  • PDF or Word export
  • Large tables
  • Strict formatting
  • Pixel-perfect layout

👉 The correct answer is possibly Paginated Report.

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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Create Visual Calculations by Using DAX (PL-300 Exam Prep)

 
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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Configure Bookmarks (PL-300 Exam Prep)

 
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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Create custom tooltips (PL-300 Exam Prep)

 
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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Edit and Configure Interactions Between Visuals (PL-300 Exam Prep)

 
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

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI

Practice Questions: Configure navigation for a report (PL-300 Exam Prep)

 
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