You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.
You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content
NOTE: Each correct selection is worth one point
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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a report in Power BI Desktop as 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.
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to create the dataset. Which dataset mode should you use?
You have a report page that contains the visuals 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.
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
