Question 236

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 median line by using the Salary measure.
Does this meet the goal?
  • Question 237

    You have a Power Bl semantic model that contains a table named Opportunity.
    The Opportunity table contains a column named Qualification
    The Qualification column contains values between 0 and V
    You need to build a new measure to score the opportunities on a scale of low, medium, and high.
    How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 238

    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 modify the source step of the queries to use DataSourceExcel as the file path.
    Does this meet the goal?
  • Question 239

    You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
    You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.
    Which report setting should you configure?
  • Question 240

    You have the following table named Location.

    The GeoCode column represents the country where each customer is located.
    You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

    You need to ensure that the map displays the country locations.
    What should you do?