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?

• A.Create a horizontal line that has a fixed value of 24,000.
• B.Add a measure to the visual that uses the following DAX expression.
  Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40)
• C.Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• D.Add a measure to the visual that uses the following DAX expression.
  Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Correct Answer: C

Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart


Add percentile lines to monitor daily revenue

Comment: *

Name: *

Email: *

Verification: *

You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
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:
When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.
Step 1: Open the Dashboard.
Step 2: Change the dashboard view to Phone view
Step 3: Pin items from the reports to the dashboard.
Step 4: Rearrange, resize, or remote items from the Phone view.
Create a phone view of a dashboard
1. In the Power BI service, open a dashboard (Step 1)
2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step 2)

The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.
3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.
The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.
4. If you change your mind, select Reset tiles to put them back in the size and order they were before.
5. When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.
Power BI saves the phone layout automatically.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-create-dashboard-mobile-phone-view

Comment: *

Name: *

Email: *

Verification: *

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.

• A.Group the impressions by Ad_id, Site_name, and Impression_date.
  Aggregate by using the CountRows function.
• B.Create one-to-many relationships between the tables.
• C.Create a calculated table that contains Ad_id, Site_name, and Impression_date.
• D.Create a calculated measure that aggregates by using the COUNTROWS function.

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a median line by using the Salary measure.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *