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],©.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)
Answer: C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
Latest PL-300 Dumps Valid Version with 131 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund