You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order.

What should you configure in Microsoft Power Bl Desktop?

Reveal Solution Hide Solution

What is the minimum number of datasets and storage modes required to support the reports?

Reveal Solution Hide Solution

HOTSPOT

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales.

CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Yes

The Related function returns a related value from another table.

The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.

Box 2: Yes

Box 3: No

TX only occurs in the Sales table, but not in the CityData table.

Reference:

https://docs.microsoft.com/en-us/dax/related-function-dax

https://docs.microsoft.com/en-us/dax/calculate-function-dax

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region

information.

You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You receive revenue data that must be included in Microsoft Power Bl reports.

You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.

You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select Use Header as First Row.

Step 2: Select Department and Product and Unpivot Other Columns

Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.

Step 3: Rename the Attribute column to Year and the Value column to Revenue.

You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the

new columns and re-orient them into flattened columns:

Values (in blue on the left) are unpivoted into a new column (in blue on the right).

Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.

Reference: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

DRAG DROP

You receive revenue data that must be included in Microsoft Power Bl reports.

You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.

You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select Use Header as First Row.

Step 2: Select Department and Product and Unpivot Other Columns

Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.

Step 3: Rename the Attribute column to Year and the Value column to Revenue.

You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the

new columns and re-orient them into flattened columns:

Values (in blue on the left) are unpivoted into a new column (in blue on the right).

Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.

Reference: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

You need to create a calculated column to display the month based on the reporting requirements.

Which DAX expression should you use?

Reveal Solution Hide Solution

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Reveal Solution Hide Solution