New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DA-100 Topic 5 Question 10 Discussion

Actual exam question for Microsoft's DA-100 exam
Question #: 10
Topic #: 5
[All DA-100 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

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.


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

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel