Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 13 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: A Power BI Data Analyst is designing a dashboard to compare monthly sales totals across three product categories (Electr. Follow @CertPunch and visit certpunch.com for more certification practice exams and study content.
Prefer hands-on? Take this round as an interactive practice test — answer every question, get instant feedback, and see your score: Start the Microsoft Power BI Data Analyst Associate (PL-300) practice test →
What you will practice
- A Power BI Data Analyst is designing a dashboard to compare monthly sales totals across three product categor…
- You are discussing the functionalities of Power BI's Report Editor. Which area allows you to apply and modify…
- A Power BI Data Analyst is importing a dataset from an Excel file containing customer feedback with a Comment…
- A Power BI Data Analyst is working with a Sales table containing a SalesAmount column. The analyst needs to c…
- A Power BI Data Analyst has published a report to the Power BI Service with a dataset connected to an on-prem…
- A Power BI Data Analyst has created a table visual showing sales data by product. The analyst wants to highli…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. A Power BI Data Analyst is designing a dashboard to compare monthly sales totals across three product categories (Electronics, Clothing, and Furniture) for the current year. The analyst wants to use a visual that clearly shows the differen…
Answer: C. A clustered column chart with months on the x-axis and categories as separate columns.
Option C is correct because placing columns side-by-side within each month provides the clearest direct comparison between the three product categories. A pie chart fails because it aggregates all months, completely losing the intended month-by-month breakdown analysis.
Q2. You are discussing the functionalities of Power BI's Report Editor. Which area allows you to apply and modify filters for your visualizations?
Answer: D. Filters pane
Option D is correct because the Filters pane centralizes management for visual, page, and report-level filtering. The Fields pane only lists tables and columns for selection, while the Visualizations pane formats charts rather than directly managing the applied filters.
Q3. A Power BI Data Analyst is importing a dataset from an Excel file containing customer feedback with a Comments column. The analyst notices that the Comments column contains inconsistent capitalization (e.g., "Good service", "GOOD SERVICE"…
Answer: C. Use the "Format" option in Power Query to apply Title Case to the Comments column.
Option C is correct because the built-in Format option within Power Query provides a direct way to apply capitalization changes cleanly. Option E fails because DAX lacks a native title case function, and data transformation should always occur before loading the model.
Q4. A Power BI Data Analyst is working with a Sales table containing a SalesAmount column. The analyst needs to create a new column in Power Query to categorize sales as "High" (SalesAmount ≥ 1000), "Medium" (SalesAmount between 500 and 999)…
Answer: D. Use the "Conditional Column" feature in Power Query to define the High, Medium, and Low categories based on SalesAmount.
Using the Conditional Column feature in Power Query provides a user-friendly interface to define rules for categorizing data based on specified ranges. Writing a complex custom M formula is incorrect because it requires unnecessary manual coding when a built-in interface exists.
Q5. A Power BI Data Analyst has published a report to the Power BI Service with a dataset connected to an on-premises SQL Server database via a gateway. The dataset needs to refresh daily at 8 AM to ensure users see the latest data. The analys…
Answer: A. Configure a scheduled refresh in the Power BI Service for the dataset, setting it to run daily at 8 AM using the on-premises data gateway.
Configuring a scheduled refresh in the Power BI Service uses the on-premises data gateway to connect to the SQL Server, ensuring automatic daily updates. Option B fails because bypassing the gateway prevents the Power BI Service from accessing the secure on-premises database.
Q6. A Power BI Data Analyst has created a table visual showing sales data by product. The analyst wants to highlight products where sales are below $10,000 by displaying those rows with a red background color to draw attention to underperformi…
Answer: D. Conditional formatting with background color rules
Applying conditional formatting with background color rules dynamically highlights specific rows based on their underlying numerical values. This approach draws immediate attention to outliers without manually filtering out the data.
Q7. At DataLens Analytics, your manager wants a report showing the impact of a marketing campaign. The report should display the "Before Campaign" data and "After Campaign" data using the same visuals and layout. Which feature should you use t…
Answer: B. Create two bookmarks: one for "Before Campaign" and one for "After Campaign."
Bookmarks capture the current state of selected visuals, filters, and properties without altering the base report layout. Slicers are a strong distractor, but bookmarks efficiently swap data contexts while maintaining identical canvas positions.
Q8. Which of the following statements regarding error handling in Power BI is true?
Answer: A. Error handling in Power BI allows you to define custom actions when encountering errors during data transformation or query execution.
Option A is correct because Power Query provides specific transformations to handle data quality issues. Option B fails because Power BI provides built-in options like Remove Errors or Replace Values rather than just displaying messages.
Q9. You are working in Power BI and need to create bins for the CustomerAge column. Which of the following options is not available in the Groups configuration window?
Answer: C. Aggregation Method
Option C is correct because configuring bins relies on setting size or range boundaries, not applying math functions. Aggregations like Sum or Average are handled later in DAX measures or visual calculations rather than during the grouping step.
Q10. What is the primary purpose of the CROSSFILTER function in DAX?
Answer: A. To change the cross-filter direction between two tables while maintaining the original settings.
Option A is correct because CROSSFILTER modifies how filters propagate between tables for a specific calculation without permanently altering the model relationship. Option B fails because relationships must be created in the model view rather than via DAX.
Q11. A Power BI Data Analyst is designing an interactive report with two pages: one showing sales by region and another showing sales by product category. The analyst wants to allow users to toggle between two chart types (bar and pie) on the r…
Answer: A. Use bookmarks to capture the state of the report with bar and pie charts and link buttons to these bookmarks.
Option A is correct because bookmarks save the visibility and state of visuals, which can then be triggered by buttons. Field parameters cannot switch core visual types, making option C an impossible workaround for dynamically changing native chart formats.
Q12. You are working on the Sales table and decide to create a Running Total measure using the Quick Measures pane to track cumulative sales over time. You use the OrderDate column as the time reference. After creating the running total, you fi…
Answer: B. The running total will recalculate and show cumulative sales only for the selected year.
Option B is correct because the DAX measure evaluates within the current filter context, resetting the cumulative sum for the selected year. Option A fails because CALCULATE respects visual filters unless explicitly overridden with functions like REMOVEFILTERS.
Q13. At SkyMetrics Corp., your Sales table contains the following columns: – Quantity – UnitPrice – Discount Your manager asks you to calculate the total revenue for each row in the Sales table by taking the discount into account. The formula f…
Answer: B. Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice] * (1 – Sales[Discount]))
SUMX is an iterator function that evaluates the row-level expression first, then sums the results. Standard SUM cannot evaluate multiple row-level columns multiplied together without an iterator.
More Microsoft Power BI Data Analyst Associate (PL-300) drills and other practice exams are on @CertPunch. New rounds drop every few days at certpunch.com.