Question 36

You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Question 37

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?
  • Question 38

    You are enhancing a Power BI model that has DAX calculations.
    You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
    Which DAX functions should you use? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 39

    You have the tables shown in the following table.

    The Impressions table contains approximately 30 million records per month.
    You need to create an ad analytics system to meet the following requirements:
    Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
    Minimize the data model size.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 40

    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.