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?
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
Each employee has one manager as shown in the ParentEmployeelD column,
All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
Which DAX expression should you use?
You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access:
* External users can access the dashboard.
* Managers can access the dashboard and a manager-specific report.
* Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?
You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.
What should you do?
You have a Power BI data model that contains a table named Employees. The table has the following columns:
* Employee Name
* Email Address
* Start Date
* Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
* Users must see only their own employee data
* The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?
Fletcher
Dona
5 days agoGeorgiana
26 days agoHortencia
1 months agoJess
1 months agoCathrine
2 months agoAnnette
2 months agoYoulanda
2 months agoKristofer
3 months agoErasmo
3 months agoLezlie
3 months agoBrunilda
3 months agoAlise
4 months agoLaura
4 months agoMiesha
4 months agoCornell
4 months agoShanice
5 months agoRosalia
5 months agoShalon
5 months agoCallie
5 months agoLaine
5 months agoFlo
6 months agoCassi
6 months agoRonnie
6 months agoDahlia
6 months agoMillie
7 months agoGretchen
7 months agoTegan
7 months agoElza
7 months agoJani
7 months agoDana
8 months agoKarima
8 months agoMel
8 months agoMatthew
8 months agoSamuel
9 months agoNell
9 months agoAlberta
10 months agoChantay
10 months agoAileen
10 months agoDenae
11 months agoLeatha
11 months agoalezza
11 months agoshelisha
11 months agoelishaa
11 months agokallis
11 months agoAdria
12 months ago