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. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,sales[Total Sales],0.40)

B. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.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. Create a horizontal line that has a fixed value of 24,000.








 

Suggested Answer: C

The analytics feature enables you to show percentiles across groups specified along a specific axis.
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
 
 
Reference: alt="Reference Image" />
 https://www.dash-intel.com/powerbi/statistical_functions_percentile.php

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.