This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Model the data (25–30%)
   --> Create model calculations by using DAX
      --> Create calculation groups

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 calculation group?

A. To replace all measures in a model
B. To apply reusable calculation logic to multiple measures
C. To improve data refresh performance
D. To create row-level security rules

Correct Answer: B

Explanation:
Calculation groups allow a single calculation (such as YTD or YoY) to be reused across multiple measures using SELECTEDMEASURE().

---

Question 2

Which function is REQUIRED when defining a calculation item?

A. CALCULATE
B. VALUES
C. SELECTEDVALUE
D. SELECTEDMEASURE

Correct Answer: D

Explanation:
SELECTEDMEASURE() references the measure currently in context, allowing the calculation group to work dynamically across measures.

---

Question 3

Where are calculation groups created?

A. Power BI Desktop
B. Power Query Editor
C. Tabular Editor
D. DAX Studio

Correct Answer: C

Explanation:
Calculation groups are created using Tabular Editor, an external modeling tool. They cannot be created directly in Power BI Desktop.

---

Question 4

Which scenario is BEST suited for a calculation group?

A. Creating a one-time KPI
B. Creating a simple ratio measure
C. Applying YTD, MTD, and YoY logic across many measures
D. Cleaning source data

Correct Answer: C

Explanation:
Calculation groups excel when the same calculation logic must apply consistently across many measures.

---

Question 5

What happens if multiple calculation groups exist in a model?

A. Power BI randomly applies one
B. Only the most recent one is used
C. Calculation precedence determines the order of execution
D. All calculation groups are ignored

Correct Answer: C

Explanation:
Calculation groups are applied based on precedence. Higher precedence values are evaluated first.

---

Question 6

Which statement about calculation groups is TRUE?

A. They are evaluated during data refresh
B. They increase model storage size significantly
C. They modify measures at query time
D. They can replace the need for base measures

Correct Answer: C

Explanation:
Calculation groups operate at query time, modifying how measures are evaluated without storing additional data.

---

Question 7

Why might a calculation group cause unexpected results?

A. It automatically filters fact tables
B. It overrides measure logic due to precedence
C. It recalculates columns dynamically
D. It disables relationships

Correct Answer: B

Explanation:
Incorrect calculation precedence can cause calculation groups to override or interfere with other calculations.

---

Question 8

Which is a limitation of calculation groups?

A. They cannot be used with measures
B. They require Power Query
C. They are not supported for all DirectQuery sources
D. They cannot be used in visuals

Correct Answer: C

Explanation:
Some DirectQuery sources have limited or no support for calculation groups, making them unsuitable in those scenarios.

---

Question 9

When should calculation groups generally NOT be used?

A. Large enterprise models
B. Models with many similar measures
C. Simple reports with only a few measures
D. Time intelligence scenarios

Correct Answer: C

Explanation:
In simple models, calculation groups may add unnecessary complexity and reduce clarity for report authors and users.

---

Question 10

Which best practice aligns with PL-300 guidance?

A. Use calculation groups to replace all measures
B. Use calculation groups only when they improve maintainability
C. Always create calculation groups for time intelligence
D. Avoid documentation when using calculation groups

Correct Answer: B

Explanation:
The exam emphasizes judgment and maintainability. Calculation groups should be used when they meaningfully simplify and standardize the model.

---

Key Exam Takeaways

• ✔ Calculation groups apply reusable logic to measures
• ✔ SELECTEDMEASURE() is foundational
• ✔ Created using Tabular Editor
• ✔ Precedence matters
• ❌ Not always appropriate for simple models

---

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:
Model the data (25–30%)
 --> Optimize model performance
    --> Improve Performance by Identifying and Removing Unnecessary Rows and Columns

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

1. Why does removing unused columns improve Power BI model performance?

A. It reduces the number of visuals that can be created
B. It decreases the number of DAX measures required
C. It reduces memory usage in the VertiPaq engine
D. It disables automatic relationships

✅ Correct Answer: C

Explanation:
Power BI stores data in the VertiPaq in-memory engine. Each column consumes memory—even if it is hidden. Removing unused columns reduces the model’s memory footprint, leading to faster refreshes and better query performance.

---

2. Where should unnecessary rows ideally be removed to achieve the best performance improvement?

A. In DAX measures
B. In calculated tables
C. In report-level filters
D. In Power Query

✅ Correct Answer: D

Explanation:
Removing rows in Power Query prevents the data from ever being loaded into the model. This reduces model size and improves refresh and query performance. Filtering data after it’s loaded (DAX or visuals) does not reduce memory usage.

---

3. Which type of column typically has the greatest negative impact on model size?

A. Numeric columns with repeated values
B. Boolean columns
C. High-cardinality text columns
D. Date columns

✅ Correct Answer: C

Explanation:
High-cardinality text columns (e.g., IDs, comments, URLs) compress poorly in VertiPaq and significantly increase model size. Removing unused high-cardinality columns is a key performance optimization technique.

---

4. A column is hidden in the model but not used in any visuals or calculations. What impact does it have on performance?

A. No impact, because it is hidden
B. It improves compression automatically
C. It still consumes memory
D. It is removed at refresh time

✅ Correct Answer: C

Explanation:
Hidden columns are still loaded into the model and consume memory. Hiding a column does not improve performance—removing it does.

---

5. Which scenario best justifies removing historical rows from a fact table?

A. The data refresh fails intermittently
B. Reports only require the last three years of data
C. Measures return incorrect totals
D. Relationships are inactive

✅ Correct Answer: B

Explanation:
If reports only require recent data, removing older historical rows reduces table size and improves performance without affecting business requirements.

---

6. Why is removing unnecessary columns from fact tables especially important?

A. Fact tables rarely participate in relationships
B. Fact tables usually have the fewest rows
C. Fact tables typically have the most rows
D. Fact tables do not support compression

✅ Correct Answer: C

Explanation:
Fact tables often contain millions of rows. Any unnecessary column in a large fact table significantly increases memory usage and query processing time.

---

7. Which action improves performance without reducing the model size?

A. Removing unused columns in Power Query
B. Filtering rows in Power Query
C. Using report-level filters
D. Removing columns from the source system

✅ Correct Answer: C

Explanation:
Report-level filters limit what is displayed but do not remove data from the model. The data is still loaded and stored in memory.

---

8. Which of the following columns is most likely safe to remove if not used?

A. Date key used in relationships
B. Surrogate key not used in any relationship
C. Foreign key linking to a dimension
D. Numeric measure column

✅ Correct Answer: B

Explanation:
Surrogate keys that are not used in relationships, visuals, or calculations add no analytical value and only increase model size.

---

9. Why is early filtering in Power Query recommended?

A. It increases DAX calculation accuracy
B. It enables query folding and reduces data transfer
C. It hides rows from report users
D. It automatically creates relationships

✅ Correct Answer: B

Explanation:
Filtering early allows Power BI to push filtering logic back to the data source (query folding), reducing the amount of data transferred, loaded, and stored in the model.

---

10. A Power BI model is slow, and analysis shows many unused descriptive columns in dimension tables. What is the BEST action?

A. Hide the columns
B. Convert them to measures
C. Remove the columns in Power Query
D. Create calculated columns instead

✅ Correct Answer: C

Explanation:
Removing unused descriptive columns in Power Query permanently reduces model size and improves performance. Hiding columns does not provide performance benefits.

---

Final Exam Tips

• Remove, don’t hide unused columns
• Filter rows in Power Query, not visuals
• Focus on high-cardinality columns and large fact tables
• Smaller models = faster performance (this is a recurring PL-300 theme)

---

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:
Model the data (25–30%)
   --> Optimize model performance
      --> Identify poorly performing measures, relationships, and visuals by using 
          Performance Analyzer and DAX query view

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 run Performance Analyzer on a report page and notice that a visual has a very high DAX Query duration but a low Visual Display duration. What is the most likely cause?

A. The visual contains too many fields
B. The measure used by the visual is inefficient
C. The report page has too many visuals
D. The dataset refresh frequency is too high

✅ Correct Answer: B

Explanation:
A high DAX Query time indicates that the bottleneck occurs during DAX execution, which typically points to inefficient measures, complex calculations, or inefficient filter context.

---

Question 2

Which Power BI tool allows you to view and execute DAX queries generated by report visuals?

A. Model View
B. Performance Analyzer
C. DAX Query View
D. Power Query Editor

✅ Correct Answer: C

Explanation:
DAX Query View enables analysts to inspect and test DAX queries independently of visuals, making it ideal for diagnosing measure-level performance issues.

---

Question 3

You observe that multiple visuals across different report pages are slow, even though they use different visual types. What is the most likely root cause?

A. A complex report theme
B. Inefficient shared measures
C. Excessive visual formatting
D. Dataset refresh settings

✅ Correct Answer: B

Explanation:
If multiple visuals are slow across pages, the issue is often a shared measure or relationship rather than a visual-specific configuration.

---

Question 4

Which Performance Analyzer metric helps you determine whether slowness is caused by rendering rather than DAX?

A. Total Load Time
B. DAX Query
C. Other
D. Visual Display

✅ Correct Answer: D

Explanation:
High Visual Display time indicates the visual itself (layout, formatting, or rendering complexity) is the primary performance bottleneck.

---

Question 5

Which relationship configuration is most likely to negatively impact model performance?

A. One-to-many with single direction
B. Many-to-many with bi-directional filtering
C. One-to-one with single direction
D. Inactive relationship

✅ Correct Answer: B

Explanation:
Many-to-many relationships combined with bi-directional filtering significantly increase filter propagation complexity and often degrade performance.

---

Question 6

You copy a DAX query from Performance Analyzer and run it in DAX Query View. Why is this useful?

A. To change the visual’s formatting
B. To validate data refresh schedules
C. To isolate and analyze query performance
D. To modify relationships automatically

✅ Correct Answer: C

Explanation:
Running queries in DAX Query View helps isolate performance issues at the DAX level, independent of visual rendering.

---

Question 7

A table visual renders slowly, but Performance Analyzer shows low DAX Query time. What should you investigate next?

A. Measure logic
B. Data model relationships
C. Visual complexity and row count
D. Dataset size on disk

✅ Correct Answer: C

Explanation:
Low DAX time but slow rendering suggests the issue is visual-related—such as high row counts, many columns, or heavy formatting.

---

Question 8

Which DAX pattern is most commonly associated with poor performance when overused?

A. Simple aggregations like SUM
B. Iterators such as SUMX and FILTER
C. Implicit measures
D. Column sorting

✅ Correct Answer: B

Explanation:
Iterator functions evaluate row by row and can significantly slow down DAX queries when used excessively or unnecessarily.

---

Question 9

Why can unnecessary bi-directional relationships negatively affect report performance?

A. They increase dataset size
B. They prevent refresh from completing
C. They increase filter propagation complexity
D. They disable query folding

✅ Correct Answer: C

Explanation:
Bi-directional filtering increases the number of filter paths Power BI must resolve, often leading to slower query execution.

---

Question 10

What is the primary purpose of Performance Analyzer in Power BI Desktop?

A. Optimize dataset refresh times
B. Rewrite inefficient DAX automatically
C. Identify which visuals are slow and why
D. Monitor gateway performance

✅ Correct Answer: C

Explanation:
Performance Analyzer helps identify slow visuals and breaks down execution time, allowing analysts to pinpoint whether the issue lies in DAX, rendering, or other overhead.

---

Key Exam Takeaways

• Performance Analyzer identifies where time is spent
• DAX Query View helps analyze why queries are slow
• High DAX Query time → measure or relationship issue
• High Visual Display time → visual design issue
• Bi-directional and many-to-many relationships are frequent performance culprits

---

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:
Model the data (25–30%)
   --> Optimize model performance
      --> Improve Performance by Reducing Granularity

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

1. A Power BI model contains a Sales table with one row per transaction, including TransactionID, DateTime, ProductID, and SalesAmount. Reports only show daily sales totals. What is the BEST way to improve performance?

A. Create a calculated column to extract the date
B. Create a measure that sums SalesAmount
C. Aggregate the Sales table to daily totals in Power Query
D. Create a calculated table using SUMMARIZE

Correct Answer: C

Explanation:
Aggregating the table to daily totals before loading the data reduces row count and model size. Power Query aggregation is more efficient than DAX-based aggregation and is a best practice for performance optimization.

---

2. Which type of column most commonly increases granularity without adding analytical value?

A. Date
B. Product category
C. Transaction ID
D. Sales amount

Correct Answer: C

Explanation:
Transaction IDs are typically unique and dramatically increase granularity and cardinality. If they are not used for analysis, they should be removed to improve performance.

---

3. A dataset refresh is slow due to millions of rows from an IoT table with second-level timestamps. Reports only analyze data by day. What should you do?

A. Convert the timestamp to text
B. Remove the timestamp column
C. Aggregate the data by date in Power Query
D. Use DirectQuery instead of Import

Correct Answer: C

Explanation:
Aggregating the data by date significantly reduces granularity and row count, improving both refresh and query performance.

---

4. What is the PRIMARY trade-off when reducing granularity in a fact table?

A. Increased memory usage
B. Reduced model refresh frequency
C. Loss of detailed drill-down capability
D. Slower DAX calculations

Correct Answer: C

Explanation:
Reducing granularity improves performance but can limit the ability to drill into detailed records, such as individual transactions.

---

5. Which approach is MOST appropriate when users need both summary-level performance and occasional transaction-level analysis?

A. Keep only transaction-level data
B. Reduce granularity and remove detail
C. Use aggregation tables with a detailed fact table
D. Create calculated measures for aggregation

Correct Answer: C

Explanation:
Aggregation tables allow Power BI to use summarized data for most queries while retaining access to detailed data when needed.

---

6. Why does reducing granularity improve VertiPaq engine performance?

A. It increases the number of relationships
B. It reduces the number of visuals per report
C. It lowers row count and column cardinality
D. It forces single-direction filtering

Correct Answer: C

Explanation:
VertiPaq performs best with fewer rows and lower cardinality. Reducing granularity directly improves compression and query speed.

---

7. Which of the following is the BEST indicator that a table’s granularity is too high?

A. Many measures use CALCULATE
B. The table has a high row count but few visuals use it directly
C. The table contains many numeric columns
D. The table uses Import mode

Correct Answer: B

Explanation:
If a table contains massive detail that is never used in visuals or analysis, its granularity is likely higher than required.

---

8. A fact table includes a DateTime column with values down to the second. Reports only use Year and Month. What is the BEST action?

A. Hide the DateTime column
B. Replace DateTime with a Date column
C. Convert DateTime to text
D. Create a Year-Month calculated column

Correct Answer: B

Explanation:
Replacing DateTime with a Date column reduces cardinality and improves performance. Simply hiding the column does not improve the model.

---

9. Which optimization should be done FIRST when addressing performance issues caused by excessive granularity?

A. Rewrite DAX measures
B. Change relationship direction
C. Reduce rows and columns during data preparation
D. Enable bidirectional filtering

Correct Answer: C

Explanation:
Model-level optimizations—such as removing unnecessary rows and reducing granularity—should always be done before tuning DAX.

---

10. Which statement BEST reflects a PL-300 best practice regarding granularity?

A. Always store the most detailed data possible
B. Reduce granularity only after publishing the report
C. Match data granularity to actual reporting requirements
D. Use calculated tables instead of Power Query aggregation

Correct Answer: C

Explanation:
The optimal granularity is the lowest level of detail that still supports business questions. Overly detailed data harms performance without adding value.

---

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%)
   --> Create reports
      --> Select an appropriate visual

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 compare total sales across multiple product categories. Each category has a single aggregated value.
Which visual is most appropriate?

A. Line chart
B. Scatter chart
C. Column chart
D. Card

Correct Answer: C

Explanation:
Column (or bar) charts are best for comparing values across discrete categories. Line charts are better for trends over time, and cards only show a single value.

---

Question 2

A business user wants to see how revenue changes month over month for the last three years.
Which visual should you choose?

A. Area chart
B. Line chart
C. Pie chart
D. Treemap

Correct Answer: B

Explanation:
Line charts are ideal for showing trends over time and are the standard choice for time-series analysis in Power BI.

---

Question 3

You want to show the percentage contribution of each region to total sales, with only four regions.
Which visual is most appropriate?

A. Table
B. Scatter chart
C. Pie chart
D. Waterfall chart

Correct Answer: C

Explanation:
Pie charts are appropriate for part-to-whole comparisons when there are only a few categories. With many categories, they become difficult to interpret.

---

Question 4

A report needs to highlight a single KPI: Total Revenue for the current year.
Which visual should you use?

A. Gauge
B. Card
C. Column chart
D. Matrix

Correct Answer: B

Explanation:
A card visual is designed to display a single aggregated value clearly and prominently.

---

Question 5

You want to analyze the relationship between advertising spend and total sales to see if higher spend correlates with higher sales.
Which visual is best?

A. Line chart
B. Scatter chart
C. Stacked column chart
D. Treemap

Correct Answer: B

Explanation:
Scatter charts are used to analyze relationships between two numerical measures and are ideal for identifying correlations and outliers.

---

Question 6

A user wants to see how total sales break down by category and subcategory in a hierarchical way.
Which visual should you choose?

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

Correct Answer: C

Explanation:
Treemaps are designed to display hierarchical data and part-to-whole relationships at multiple levels.

---

Question 7

You want to compare actual sales versus target sales across multiple regions.
Which visual is most appropriate?

A. Stacked bar chart
B. Scatter chart
C. Line chart
D. Card

Correct Answer: A

Explanation:
A stacked bar (or column) chart allows easy comparison between actual and target values across categories.

---

Question 8

A report must show the distribution of order values to identify outliers.
Which visual best supports this requirement?

A. Line chart
B. Pie chart
C. Histogram
D. Card

Correct Answer: C

Explanation:
Histograms are used to show the distribution of numeric data and are effective for spotting skewness and outliers.

---

Question 9

You want to display sales trends for multiple regions side-by-side without cluttering a single chart.
Which Power BI feature or visual approach is most appropriate?

A. Pie charts
B. Small multiples
C. KPI visuals
D. Gauge charts

Correct Answer: B

Explanation:
Small multiples allow you to repeat the same visual across categories, making comparisons easier without overcrowding a single chart.

---

Question 10

Which of the following is the most important factor when selecting a visual in Power BI?

A. The number of available visuals
B. The visual that looks the most impressive
C. The business question being answered
D. The amount of data in the model

Correct Answer: C

Explanation:
Visual selection should always be driven by the business question and the insight you want to communicate, not by aesthetics or volume of data.

---

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%)
   --> Create reports
      --> Format and configure 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 column chart displays revenue by product category, but users want to see the exact revenue values directly on the bars.
What should you configure?

A. Enable the legend
B. Enable data labels
C. Change the chart type
D. Adjust the axis scale

Correct Answer: B

Explanation:
Data labels display exact values directly on the visual, allowing users to see precise figures without hovering.

---

Question 2

A report contains a line chart showing monthly sales, but the values are difficult to interpret because they are displayed as large numbers (for example, 1250000).
What is the best formatting adjustment?

A. Change the visual to a table
B. Apply conditional formatting
C. Set display units to millions
D. Enable tooltips

Correct Answer: C

Explanation:
Using display units such as millions or thousands improves readability while preserving trend interpretation.

---

Question 3

A legend on a stacked bar chart overlaps with data points, making the chart difficult to read.
What is the most appropriate solution?

A. Remove the legend
B. Change the visual type
C. Move the legend position
D. Disable interactions

Correct Answer: C

Explanation:
Repositioning the legend improves readability without removing useful category information.

---

Question 4

A stakeholder wants negative variance values in a table to stand out visually.
Which configuration best meets this requirement?

A. Apply a report theme
B. Sort the table descending
C. Use conditional formatting with color rules
D. Increase font size

Correct Answer: C

Explanation:
Conditional formatting allows you to apply visual cues, such as red coloring, to values that meet specific conditions.

---

Question 5

Two visuals showing sales by region use different colors for the same regions, confusing report users.
What should you do to fix this?

A. Remove one of the visuals
B. Apply consistent category colors
C. Enable data labels
D. Disable cross-filtering

Correct Answer: B

Explanation:
Using consistent colors for the same categories across visuals improves comprehension and reduces confusion.

---

Question 6

A bar chart should display categories ranked from highest sales to lowest sales.
Which setting should you adjust?

A. Axis scale
B. Sort order
C. Data labels
D. Visual interactions

Correct Answer: B

Explanation:
Sorting the visual by the sales measure in descending order ensures categories appear in the correct ranking.

---

Question 7

A KPI visual should clearly indicate whether performance meets a target.
Which configuration best supports this requirement?

A. Add a legend
B. Enable conditional formatting
C. Change font type
D. Adjust background transparency

Correct Answer: B

Explanation:
Conditional formatting helps visually distinguish between values that meet or miss targets, improving quick interpretation.

---

Question 8

A report consumer wants to see percentage values instead of decimals (for example, 0.25 instead of 25%).
Where should this formatting be applied?

A. In the visual’s title settings
B. In the axis settings
C. In the field’s number formatting
D. In the report theme

Correct Answer: C

Explanation:
Number formatting for fields controls how values such as percentages and decimals are displayed across visuals.

---

Question 9

Selecting a bar in one visual highlights related data in another visual, but users want the second visual to filter instead of highlight.
What should you configure?

A. Drill-through settings
B. Sorting behavior
C. Visual interactions
D. Legend position

Correct Answer: C

Explanation:
Visual interactions control whether visuals filter, highlight, or ignore selections from other visuals.

---

Question 10

Which principle should guide all formatting and configuration decisions in Power BI visuals?

A. Use as many formatting options as possible
B. Match the formatting used in other reports exactly
C. Improve clarity and accuracy for the end user
D. Make visuals visually impressive

Correct Answer: C

Explanation:
Formatting should always support clear, accurate communication of insights, not aesthetics or complexity.

---

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%)
   --> Create reports
      --> Create a narrative visual with Copilot

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 consumer wants a written explanation summarizing trends and key insights shown on a report page.
Which Power BI feature best meets this requirement?

A. Smart narrative
B. Text box
C. Narrative visual with Copilot
D. Tooltip

Correct Answer: C

Explanation:
A narrative visual with Copilot automatically generates written insights based on report data and context, making it ideal for summarizing trends and patterns.

---

Question 2

Which requirement is best addressed by using a narrative visual with Copilot?

A. Creating custom DAX calculations
B. Explaining insights to non-technical users
C. Improving model performance
D. Applying conditional formatting

Correct Answer: B

Explanation:
Copilot narratives are designed to explain insights in natural language, helping non-technical audiences understand what the data shows.

---

Question 3

A Copilot-generated narrative changes when slicer selections are updated.
Why does this happen?

A. The narrative is static and refreshed manually
B. Copilot recalculates DAX measures
C. The narrative is context-aware
D. Visual interactions are disabled

Correct Answer: C

Explanation:
Copilot narratives respond dynamically to filters and slicers, ensuring the explanation reflects the current data context.

---

Question 4

A business stakeholder wants a short, automatically generated summary next to visuals in an executive dashboard.
Which approach is most appropriate?

A. Add a static text box
B. Create a table with summary metrics
C. Use a narrative visual with Copilot
D. Add tooltips to each visual

Correct Answer: C

Explanation:
Copilot narratives provide dynamic, auto-generated summaries that update as the data changes, making them ideal for executive dashboards.

---

Question 5

Which of the following best describes the role of a narrative visual with Copilot?

A. It replaces all visuals in a report
B. It performs data transformation
C. It complements visuals by explaining insights
D. It improves query performance

Correct Answer: C

Explanation:
Narrative visuals are meant to enhance report storytelling by explaining insights shown in charts, not replace visuals or perform data processing.

---

Question 6

After generating a narrative visual with Copilot, a report author wants to adjust the wording to match business terminology.
What can they do?

A. Nothing; Copilot narratives cannot be edited
B. Modify the underlying DAX measures
C. Edit the generated narrative text
D. Rebuild the data model

Correct Answer: C

Explanation:
Copilot-generated narratives can be edited by the report author to refine wording or emphasize specific insights.

---

Question 7

Which scenario is least appropriate for using a narrative visual with Copilot?

A. Providing a written summary of sales trends
B. Explaining why one category outperformed another
C. Calculating year-over-year growth
D. Summarizing filtered report data

Correct Answer: C

Explanation:
Copilot narratives do not perform calculations. Year-over-year growth requires DAX measures, not narrative visuals.

---

Question 8

A report is intended for executives who want quick insights without interpreting multiple charts.
Which Power BI feature best supports this need?

A. Decomposition tree
B. Narrative visual with Copilot
C. Matrix visual
D. Scatter chart

Correct Answer: B

Explanation:
Narrative visuals with Copilot summarize insights in plain language, making them ideal for executive and summary reporting.

---

Question 9

Which factor does Copilot use when generating a narrative visual?

A. Only the selected visual
B. The underlying Power Query transformations
C. Data model context, filters, and visuals
D. Report theme settings

Correct Answer: C

Explanation:
Copilot analyzes the data model, visuals, and current filter context to generate accurate, relevant narratives.

---

Question 10

When answering PL-300 exam questions about Copilot narrative visuals, which keyword most strongly indicates this feature is the correct solution?

A. Calculate
B. Optimize
C. Explain
D. Transform

Correct Answer: C

Explanation:
Exam questions that emphasize explaining, summarizing, or describing insights usually point to narrative visuals with Copilot rather than calculations or transformations.

---

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%)
   --> Create reports
      --> Apply and customize a theme

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 must follow company branding with consistent colors and fonts across all visuals.
Which Power BI feature best supports this requirement?

A. Conditional formatting
B. Report themes
C. Visual interactions
D. Data labels

Correct Answer: B

Explanation:
Report themes define default colors, fonts, and visual styles across the entire report, ensuring consistent branding without formatting each visual individually.

---

Question 2

Where do you apply a built-in theme in Power BI Desktop?

A. Home tab
B. Modeling tab
C. View tab
D. Insert tab

Correct Answer: C

Explanation:
Built-in themes are applied from the View tab in Power BI Desktop using the Themes gallery.

---

Question 3

A stakeholder provides a JSON file that defines corporate colors and fonts.
What should you do to apply it to your report?

A. Paste the JSON into Power Query
B. Import the JSON file as a data source
C. Browse for and apply the theme file
D. Convert the JSON to a dataset

Correct Answer: C

Explanation:
Custom themes are applied by browsing for and importing a .json theme file from the Themes menu.

---

Question 4

What happens when you apply a theme to an existing report?

A. It only affects new visuals
B. It updates the default formatting of visuals in the report
C. It removes all manual formatting
D. It changes the data model

Correct Answer: B

Explanation:
Applying a theme updates the default visual formatting across the report. Manually overridden formatting may remain unchanged.

---

Question 5

Which scenario is the best use case for creating a custom theme?

A. Calculating business metrics
B. Improving model performance
C. Enforcing branding and design standards
D. Enabling row-level security

Correct Answer: C

Explanation:
Custom themes are designed to enforce consistent branding, colors, and styles across reports.

---

Question 6

A report author wants to adjust colors and fonts without writing JSON.
Which option should they use?

A. Customize current theme
B. Power Query Editor
C. Conditional formatting
D. Visual interactions

Correct Answer: A

Explanation:
The Customize current theme dialog allows report authors to modify theme settings through the UI without editing JSON.

---

Question 7

Which element can be controlled by a Power BI theme?

A. Relationships between tables
B. DAX calculations
C. Visual color palettes and fonts
D. Data refresh schedules

Correct Answer: C

Explanation:
Themes control visual appearance such as colors, fonts, backgrounds, and default formatting—not data logic or refresh behavior.

---

Question 8

An organization wants all report creators to use approved themes managed centrally.
Which feature supports this requirement?

A. Report templates
B. Organizational themes
C. Visual-level formatting
D. Dataflows

Correct Answer: B

Explanation:
Organizational themes allow administrators to centrally manage and distribute themes for consistent use across reports.

---

Question 9

After applying a theme, some visuals do not change appearance.
What is the most likely reason?

A. The theme file is corrupted
B. The visuals are unsupported
C. Manual formatting overrides exist
D. The report must be refreshed

Correct Answer: C

Explanation:
Manual formatting applied to visuals can override theme defaults, preventing some theme changes from appearing.

---

Question 10

Which principle should guide decisions when applying or customizing a theme?

A. Use as many colors as possible
B. Match formatting across all reports exactly
C. Improve consistency and readability
D. Avoid using built-in themes

Correct Answer: C

Explanation:
Themes should improve visual consistency, clarity, and usability—not add unnecessary complexity or visual noise.

---

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%)
   --> 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