Microsoft Power BI Data Analyst — Question 3
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 section, 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 a 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?
Answer options
- A. Yes
- B. No
Correct answer: A
Explanation
The solution correctly establishes a median line using the Salary measure, which effectively indicates which employees earn above the median salary. Option B is incorrect because not creating a median line would fail to meet the goal of identifying employees above the median salary.