You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.Model1 contains the following measure.Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date]))You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual.Which value will appear in the card visual?
Answer(s): B
You have a Power BI query named Expenses that imports the following data.Users only use the date portion of the TransactionDate value when performing data analysis.You need to minimize the model size without affecting the analysis.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): A,C
DRAG DROP (Drag and Drop is not supported) You have a Microsoft Excel spreadsheet that contains the data shown in the following table.You plan to build a data model for a Power BI report.You need to prepare the data so that it is available to the model in the format shown in the following table.Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
Answer(s): A
Step 1: Select the [Department] and [Stage] columns and unpivot the other columns.We unpivot the School1, School2, School3, and the School4 columns.You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column.Example:When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:* Values (in blue on the left) are unpivoted into a new column (in blue on the right).* Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.Step 2: Rename the [Attribute] column as [School] and the [Value] column as [Score[,Step 3: Group by [Department] and [School] and..
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.How should the visual interactions be set on the column chart when the bar chart is selected?
A user creates a Power BI report named ReportA that uses a custom theme.You create a dashboard named DashboardA.You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): B,E
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.