You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country.
You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages.
What should you do?
A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
C. Move the Country slicer from page 2 and page 3 to page 1.
D. Sync the Country slicer on page 1, page 2, and page 3.
Show Answer
Correct Answer: D
Explanation: Syncing the Country slicer across page 1, page 2, and page 3 ensures that a country selection made on any of those pages is retained when navigating between them. By excluding page 4 from the slicer sync group, page 4 remains unaffected by selections made on the other pages, which meets both requirements.
Question 162
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Delete the Country column.
B. Remove duplicates from the table.
C. Remove duplicates from the City column.
D. Delete the City column.
E. Remove duplicates from the Country column.
Show Answer
Correct Answer: D, E
Explanation: The requirement is a Country dimension containing a unique list of countries only. The City column is not needed for this dimension, so it should be deleted. To ensure uniqueness, duplicates must be removed based on the Country column itself. Removing duplicates from the whole table would only eliminate fully identical rows and may not remove multiple cities per country. Therefore, deleting the City column and removing duplicates from the Country column is the correct and order-independent solution.
Question 163
You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.
You use Power Query to load a query that contains both renamed and custom columns.
Later, you attempt to reload the query and receive the following error message.
Expression.Error: The column 'Category' of the table wasn't found.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. The column was removed from the source file.
B. The column was renamed in the source file.
C. The file is no longer in the specified location.
D. The data type of the column was changed.
Show Answer
Correct Answer: A, B
Explanation: The error indicates that Power Query cannot find a column named 'Category' that is referenced in one of the query steps. This happens if the column was removed from the source file or if it was renamed in the source file, causing existing steps (such as renamed or custom columns) to reference a non-existent column.
Question 164
You have a Power BI data model that contains a table named Employees. The table has the following columns:
• Employee Name
• Email Address
• Start Date
• Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
• Users must see only their own employee data.
• The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
A. [Email Address] - USERNAME()
B. [Employee Name] - USERPRINCIPALNAME()
C. [Employee Name] = USERNAME()
D. [Email Address] = USERPRINCIPALNAME()
Show Answer
Correct Answer: D
Explanation: Dynamic RLS should match a column that uniquely identifies the user and works consistently in Desktop and Service. USERPRINCIPALNAME() always returns the user principal name (UPN) in email format (e.g., [email protected]) in both environments. Since the Employees table contains an Email Address column, filtering with [Email Address] = USERPRINCIPALNAME() correctly restricts each user to their own row. USERNAME() can return DOMAIN\\user in Desktop, making it unreliable here.
Question 166
You have a Power BI report that contains a page. The page contains the following:
• A shape named Shape1
• A card named Sales Summary
• A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape1.
What should you modify?
A. Tab order in the Selection pane
B. Layer order in the Selection pane
C. Maintain layer order in the General visual settings
D. Vertical alignment in the Canvas settings
Show Answer
Correct Answer: B
Explanation: In Power BI, the visual stacking (which object appears on top of another) is controlled by the layer order in the Selection pane. By moving the Sales Summary card above Shape1 in the Selection pane, it will render on top of the shape. Tab order, alignment, and general settings do not affect visual layering.
Question 167
You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements:
• Sales invoices must be exported in a PDF format.
• The PDF exports must show all columns and rows clearly.
What should you create?
A. a paginated report that contains a tablix
B. a dashboard that contains a table
C. an interactive report that contains a table
D. an interactive report that contains a matrix
Show Answer
Correct Answer: A
Explanation: Sales invoices require a fixed, printable layout and reliable PDF export where all rows and columns are fully rendered. Power BI paginated reports are designed for pixel-perfect, multi-page documents and export cleanly to PDF. Using a tablix data region ensures all invoice details are displayed without truncation or scrolling, unlike dashboards or interactive reports.
Question 168
DRAG DROP -
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: First step: Add a Bookmark navigator button.
Second step: Group the three bookmarks.
Third step: Change the Bookmark property for the button.
Explanation: A Bookmark navigator button is used to navigate bookmarks. To limit it to three specific bookmarks, those bookmarks must first be grouped in the Bookmarks pane. After the group exists, the navigator’s Bookmark property can be set to that group so only those three bookmarks appear.
Question 169
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.
You need to write a DAX measure that counts the number of orders.
Which formula should you use?
A. Count('Sales'[Order ID])
B. CountA('Sales' [Order ID])
C. CountRows('Sales')
D. DistinctCount('Sales' [Order ID])
Show Answer
Correct Answer: D
Explanation: Each order can have multiple rows in the Sales table because an order may contain multiple order lines (different products). Counting rows or counting the Order ID column would overcount orders. Using DISTINCTCOUNT on Order ID correctly counts each order only once, regardless of how many order lines it has.
Question 170
DRAG DROP
-
You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries.
You add a slicer named Country to each page of the report.
You need to configure the report to meet the following requirements:
• When a user selects a country on the first page, the report must filter the other pages.
• The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: When a user selects a country on the first page, the report must filter the other pages:
Add the Country field to the filters on all the pages
The second and third pages must display only the filtered results:
Configure the Country slicer to sync only on the second and third pages
Explanation: Adding the Country field as a page/report-level filter ensures all pages respond to the selected country. Syncing the slicer only to pages two and three ensures they reflect the selection while controlling slicer behavior specific to those pages.
Question 171
DRAG DROP -
You use Power BI Desktop to create a Power BI data model and a blank report.
You need to add the Word Cloud visual shown in the following exhibit to the report.
The solution must minimize development effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Show Answer
Correct Answer: From Power BI Desktop, get the Word Cloud visual from Microsoft AppSource.
Populate the Category, Value, and Excludes fields.
Format the data colors and title.
Explanation: The Word Cloud is not a default visual, so it must be imported from AppSource within Power BI Desktop. After adding the visual, assigning Category, Value, and optional Excludes fields generates the word cloud. Finally, formatting colors and the title matches the exhibit with minimal extra effort.
$19
Get all 356 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
