You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.

You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.

• A.Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter.
• B.Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight.
• C.Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.
• D.Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight.

Comment: *

Name: *

Email: *

Verification: *

You have a report in Power BI Desktop as 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:

Comment: *

Name: *

Email: *

Verification: *

You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

• A.Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
• B.From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= "United States" && [ProductCategory]= "Clothing"
• C.Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing
• D.From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= "United States"

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: *