You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.
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 have data in a Microsoft Excel worksheet as shown in the following table.
You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:
* If the discount column returns an error, a discount of 0.05 must be used.
* All the rows of data must be maintained.
* Administrative effort must be minimized.
What should you do in Power Query Editor?
