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.

Correct 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 to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

Comment: *

Name: *

Email: *

Verification: *

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

• A.Add a Top N filter to the visual.
• B.Configure the Sales Profit measure to use the RANKX function.
• C.Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
• D.Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

Comment: *

Name: *

Email: *

Verification: *

You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:
1. Pin items from report to Dashboard.
2. Open Dashboard.
3. Change the dashboard view to Phone view.
4. Rearrange, resize the visuals.

Comment: *

Name: *

Email: *

Verification: *

You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Add a column named ProdcutName that contains only the text between...
2 - Create a product hierarchy of ProductCAtegory,...
3 - Replace the use of ProductDescription in the report with the product hierarchy.

Comment: *

Name: *

Email: *

Verification: *