- (Exam Topic 4)
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the 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.
Correct Answer:
AE
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. You can sync a slicer and use it on any or all pages in a report.
* 1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
- (Exam Topic 3)
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
Correct Answer:
A
Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter
Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.
The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference:
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi
- (Exam Topic 4)
You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3.
The solution must prevent page 4 from being affected by
selections on the other pages, What should you do?
Correct Answer:
C
- (Exam Topic 4)
You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.
You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.
What should you do?
Correct Answer:
C
- (Exam Topic 4)
You have a Power B1 data model that contains two tables named Products and Sales. A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content
NOTE: Each correct selection is worth one point
Solution:
Does this meet the goal?
Correct Answer:
A
