PdfPrep.com

Does this meet the goal?

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?
A . Yes
B . No

Answer: B

Explanation:

Instead create a percentile line by using the Salary measure and set the percentile to 50%.

Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php

Exit mobile version