Exam DA-100 topic 4 question 1 discussion

DRAG DROP -
You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
✑ Identify months that have order counts above the mean.
✑ Display the mean monthly order count.
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.
Select and Place:

Suggested Answer:
Step 1: Create a 12-month...
You can use calculated measure to get the expected result.
1. Create a calculated column for the date.
2. Create a measure for 12 months moving average.
3. Drag the Line Chart into your canvas as below. (step 2 below)


Step 2: Select the line chart -
Step 3: From the Analytics pane, add a Median line
Reference:
https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041