Question 4

 

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?

  • A. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,Sales[Total Sales],0.40)
  • B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
  • C. Create a horizontal line that has a fixed value of 24,000.
  • D. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,Sales[Total Sales],0.40)


Answer : B

Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart


Comments

Post a Comment

Popular posts from this blog

Question 2

Image
  Question 2 HOTSPOT - 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. Hot Area: Answer : Explanation: Box 1: cross-filter - By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page. Box 2: cross-highlight - Example: By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page. 1. Let's see what happens when we select Moderation. 2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart cross-filters the line chart. The line chart now only displays data points for the Moderation segment. 3. Cross-highlighting retains all the original data points but dims the portion that does not apply...
Read more

Microsoft DA-100 Exam - Preparation Question 1

  Question 1 You have a Microsoft SharePoint Online site that contain several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis. What should you do? A.  Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load. B.  Get data from a SharePoint Online list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library. C.  Get data from a SharePoint Online folder and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library. D.  Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load. Answer :  C
Read more