Microsoft PL-300 Exam - Topic 3 Question 67 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 67
Topic #: 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 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?

AYes

BNo

Show Suggested Answer

Suggested Answer: B

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

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

by Bettina at May 03, 2025, 12:46 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Andree

2 months ago

Wait, are we sure this works for all datasets?

upvoted 0 times

...

Cyndy

3 months ago

Totally agree, that's how you find the median salary.

upvoted 0 times

...

Hyun

3 months ago

Median is the 50th percentile, so this is spot on.

upvoted 0 times

...

Soledad

3 months ago

Yep, definitely meets the goal!

upvoted 0 times

...

Patrick

3 months ago

That's correct, a 50% percentile line shows the median!

upvoted 0 times

...

Laine

4 months ago

I feel like this is a trick question. While the percentile line might indicate the median, I wonder if there's a more direct way to highlight employees above it.

upvoted 0 times

...

Marshall

4 months ago

I’m a bit confused. Does a percentile line actually show the median, or is it just a way to visualize the distribution?

upvoted 0 times

...

Virgie

4 months ago

I remember a practice question where we had to use reference lines, and I think this is similar. Setting it to 50% sounds correct for the median.

upvoted 0 times

...

Lisbeth

4 months ago

I think creating a percentile line at 50% should show the median, but I'm not entirely sure if that's the right way to indicate it on the chart.

upvoted 0 times

...

Colton

4 months ago

Wait, I'm a bit confused. Does the question mean I need to create a reference line at the median salary, or do I need to somehow highlight the employees who are above the median? I want to make sure I understand the goal correctly before I start working on this.

upvoted 0 times

...

Ellsworth

5 months ago

Okay, I've got this. The key is to use the Salary measure and set the percentile to 50%. That will give me the median salary, which I can then use as a reference line to identify the employees above the median.

upvoted 0 times

...

Daren

5 months ago

Hmm, I'm not sure about this one. I know how to create reference lines, but I'm not familiar with the percentile function. I'll need to double-check the documentation to make sure I'm using the right approach.

upvoted 0 times

...

Jennie

5 months ago

I think this is a straightforward question. Creating a percentile line at the 50th percentile should give me the median salary, which is exactly what the question is asking for.

upvoted 0 times

...