PL-300 · Question #124
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 h
The correct answer is A. Yes. In Power BI analytics panes for charts, a Percentile line drawn at the 50th percentile (p=50) is mathematically equivalent to the median. Setting p=50 divides the salary distribution at the midpoint: employees whose salary bars extend above the percentile line earn more than the
Question
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 percentile line by using the Salary measure and set the percentile to 50%. Does this meet the goal?
Options
- AYes
- BNo
How the community answered
(28 responses)- A75% (21)
- B25% (7)
Explanation
In Power BI analytics panes for charts, a Percentile line drawn at the 50th percentile (p=50) is mathematically equivalent to the median. Setting p=50 divides the salary distribution at the midpoint: employees whose salary bars extend above the percentile line earn more than the median. This correctly identifies employees above median salary. The solution is valid - a percentile line at p=50 achieves the same visual result as an explicit median line, making the answer Yes.
Topics
Community Discussion
No community discussion yet for this question.