PL-300 Exam - Question 219

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 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?

Examice · Accepted Answer

Creating a median line using the Salary measure will meet the goal of showing which employees are above the median salary. The median represents the middle value in a dataset; hence, a median line effectively splits the dataset into two halves — those below and those above the median value. This line will serve as a reference to identify employees with salaries above this middle value.

Sushvij · Answer

This question is in continuation of the series question # 22 of Topic 3.
Answer is Yes
We can definitely create a median line for the measure of salary (Tested)
Also the other solution in this series is create a percentile line at 50% for the salary measure because percentile value at 50 % is exactly equal to the median value.

JPGo · Answer

This should work, not sure why not.

quxxy · Answer

I guess the thing is why "no" is correct is because previously we created percentile line at 50%... So newly created measure would work but it's creating is not necessary...

hungry85 · Answer

A is correct because you create a median line which by itself is a 50th percertile

MEG_Florida · Answer

A. as median lines are references lines and would be at the 50% mark

mambamota · Answer

Should be A

TrainingCA06 · Answer

THE ONLY WAY TO CREATE A You need to create a reference line in a clustered bar char is adding the percentile line, that is in the options on analytics, next right to the formatting icon.

ExamPage · Answer

Yes.

See this shot video: https://www.projectpro.io/recipes/use-median-line-analytics-pane-power-bi

Enrique67 · Answer

Debe crear una línea de referencia para mostrar qué empleados están por encima del salario medio.
Salario medio no es lo mismo que mediana. La respuesta es la B. No

Dsbuff · Answer

A. Yes, creating a median line using the Salary measure in your clustered bar chart will meet the goal of showing which employees are above the median salary.

Dani_eL · Answer

The answer is in the question:
You need to create a reference line to show which employees are above the median salary.

What would you use percentile when it talks about Median which readily available ??
Furthermore with percentile you need to expressly put the percentage which is not the case with median, median is median and that’s it.

rcaliandro · Answer

A - Yes

0002110 · Answer

To create a reference line for showing which employees are above the median salary, you would need to calculate the median value of the Salary and then add that as a reference line to the chart. However, simply creating a median line by using the Salary measure itself would not necessarily give you the median value directly, since the Salary measure might be aggregated and doesn't directly calculate the median across employees. You would need to calculate the median of the Salary field.

sroumi · Answer

Simply using the Salary measure to add a median line won’t correctly compute the overall median salary across all employees. When you add a reference line based on the Salary measure, Power BI will typically aggregate (sum or average) the salary for each employee based on the context of the visual. It won’t automatically calculate the median value across all data.

PL-300 Exam - Question 219

Discussion