Analyzing Data with Microsoft Power BI (legacy) — Question 7
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 an average line by using the Salary measure.
Does this meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
The proposed solution of creating an average line does not meet the goal of indicating which employees are above the median salary, as the average may not accurately reflect the median value. The correct approach would be to create a reference line based on the median salary specifically, which would properly highlight employees earning above that threshold.