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?
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:
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.
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?
You have a table that contains sales data and approximately 1,000 rows.You need to identify outliers in the table.Which type of visualization should you use?
HOTSPOT -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.Hot Area:
