You have a Power Bl report
You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
* A card that shows the number of records
* A bar chart that snows total transaction amount by territory
* A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?