You have a Power BI report that contains a table visual. The visual contains a column.
The column contains whole numbers ranging from of 1 to 20.
You need to use conditional formatting to meet the following requirements:
• Visually compare the values without having to read the text containing the number.
• Show a different format for each distinct value.
• Hide the numeric value of ColumnA.
• Minimize development effort.
Which formatting should you use?
A. font color
B. icons
C. data bars
D. background color
Show Answer
Correct Answer: C
Explanation: Data bars best meet all requirements. They allow quick visual comparison of values by bar length without reading numbers, can be displayed while hiding the numeric value, and automatically handle the full range (1–20) without defining separate rules for each value. This minimizes development effort compared to icons or color-based rules, which would require managing many distinct formats.
Question 85
You have a Power BI report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users.
What should you do?
A. From the Bookmarks pane, select Focus mode, and then select Add.
B. From Report settings, select Personalize visuals.
C. From Visual options in Report settings, select Use the modern visual header with updated styling options.
D. From Tabular Editor, create a new perspective.
Show Answer
Correct Answer: B
Explanation: Enabling **Personalize visuals** in Report settings allows each user to change a visual’s type and fields for their own session without affecting the report view for other users. The changes are personal and do not modify the published report.
Question 86
HOTSPOT -
You have a Power BI workspace.
You need to create two reports that meet the following requirements:
• Report1: Optimized for printing and can be delivered to users via a scheduled email subscription
• Report2: Optimized for dynamic user interactivity
Which format should you use for each report? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Report1: Power BI paginated (.rdl)
Report2: Power BI (.pbix)
Explanation: Paginated reports are pixel-perfect, print-optimized, and support scheduled email subscriptions. Power BI (.pbix) reports are designed for interactive, dynamic user exploration.
Question 87
HOTSPOT
-
You have a Power BI report that contains the table visual shown in the following exhibit.
You need to modify the visual to display as shown in the following exhibit.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Type: Matrix
Format: Set Switch values to rows to On
Explanation: A Matrix visual is required to pivot dates into columns and measures into rows. Enabling "Switch values to rows" displays Total Cost and Total Sales as row headers, matching the transposed layout (with OrderDate placed in Columns).
Question 88
HOTSPOT
-
You have a semantic model that has the permissions shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: use Analyze in Excel with
grant the Build permission for
Explanation: The finance group has Read and Build permissions, which allow using Analyze in Excel but not administrative actions. The corp group has Read, Build, and Reshare permissions, which allow them to grant Build permission on the semantic model.
Question 89
You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
• Date
• Product
• SalesAmount
You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
A. CALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
B. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30, Max('Date'[Date])))
C. CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
D. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
Show Answer
Correct Answer: B
Explanation: A rolling 31-day total requires a continuous range of dates from the selected date back 30 days. DATESBETWEEN defines exactly that window using the current context date (MAX(Date[Date])) as the end date and 30 days prior as the start date. DATEADD only shifts the existing date context and does not inherently create a rolling range, DATESMTD is month-to-date, and DISTINCTCOUNT is not a valid way to define a rolling window.
Question 90
You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month.
Which visual should you use?
A. a line chart
B. a stacked bar chart
C. a 100% stacked bar chart
D. a waterfall chart
Show Answer
Correct Answer: B
Explanation: To compare sales performance across five regions for a single point in time (the current month), a bar-based visual is appropriate. A stacked bar chart allows straightforward comparison of absolute sales values by region. A line chart is better for trends over time, a 100% stacked bar chart emphasizes proportions rather than actual sales amounts, and a waterfall chart is intended to show incremental changes, not categorical comparisons.
Question 91
You create a Power BI report named Summary1.
You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1.
Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution.
NOTE: Each correct answer is worth one point.
A. Top Operations
B. DAX query
C. Server requests
D. Dependencies
E. Visual display
Show Answer
Correct Answer: B, E
Explanation: In Power BI Performance Analyzer, execution duration is broken down per visual into specific time components. **DAX query** shows the time spent executing the DAX query against the data model, and **Visual display** shows the time spent rendering the visual on the report canvas. These two metrics directly report execution duration, whereas the other options are not Performance Analyzer duration metrics.
Question 92
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You add an index key and normalize casing in the data source.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: A
Explanation: Yes. In DirectQuery mode, Power BI is case-insensitive, while some data sources are case-sensitive. If a column contains values that differ only by case, Power BI can treat them as duplicates, which leads to undefined results and errors. Normalizing casing in the data source resolves this root cause. Adding an index key further helps ensure row uniqueness and stability. Therefore, this solution meets the goal.
Question 93
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: Implicit type conversion does not resolve issues caused by case-sensitive text values in a DirectQuery semantic model. Undefined values and errors related to case sensitivity require normalizing or explicitly handling text casing (for example, using UPPER/LOWER or fixing values at the source), not merely converting data types.
$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.
