PowerBIAnand

  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

Question 3 You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values in a slicer on one page, the selections are not persisted on other pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A.  Replace the slicers with report-level filters. B.  Sync the slicers across the pages. C.  Create a bookmark for each slicer value. D.  Replace the slicers with page-level filters. E.  Replace the slicers with visual-level filters. Answer :  AB Explanation: A: Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter. B: You can sync a slicer and use it on any or all page...

  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...

  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