Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 43 discussion

Actual exam question from Microsoft's PL-300
Question #: 43
Topic #: 3
[All PL-300 Questions]

HOTSPOT -
You are creating a line chart in a Power BI report as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: an average reference line
With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights.

Box 2: Values -

Add a measure to drillthrough -
You can add a measure or a summarized numeric column to the drillthrough area. Drag the drillthrough field to the Drillthrough card on the drillthrough target page to apply it.
When you add a measure or summarized numeric column, you can drill through to the page when the field is used in the Value area of a visual.

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
emmanuelkech
Highly Voted 2 years, 2 months ago
An Average reference Line Axis Should be the correct answer
upvoted 158 times
Mizaan
2 years, 1 month ago
As explained here: https://radacad.com/drill-down-and-up-in-power-bi-explained#:~:text=Click%20on%20the%20single%20arrow,and%20turn%20it%20on.&text=This%20means%20now%20that%20visual,the%20quarters%20of%20that%20year.
upvoted 10 times
powerbibuddy
2 years ago
So, Axis is the correct answer?
upvoted 6 times
bdub1976
11 months, 2 weeks ago
Yes, and I don't know why they don't fix these broken answers, it's very distracting.
upvoted 13 times
...
...
...
...
nikfed
Highly Voted 2 years, 1 month ago
C and A
upvoted 11 times
...
jaume
Most Recent 3 days, 15 hours ago
My vote for "an average reference line" and for "Axis" Cannot even understand how it could work adding month and days into the values (if this would be possible in a line graoh) merging dates with numbers (number of employees)
upvoted 1 times
...
rcaliandro
3 months, 1 week ago
an average reference line, axis
upvoted 1 times
...
Dani_eL
8 months, 2 weeks ago
There is no VALUES field in that visual. Furthermore, Axis is a date/time, so basically you might want to add time values in there too. Now… if you want a full refresh with other data format, you might want to use Drill through field and add your date values there.. So answer is Average ref line and AXIS
upvoted 1 times
...
deyoz
11 months, 1 week ago
In line chart there is no field such as value. You have axis, and y axis. In y axis, we obviously have measure and in axis date. Correct answer is Average reference line and Axis.
upvoted 1 times
...
SuniltheMentor
1 year, 7 months ago
Average Reference Line and Axis is the correct answer
upvoted 6 times
...
srikanth923
1 year, 8 months ago
an average reference line, axis
upvoted 5 times
...
PaweuG
1 year, 9 months ago
Average reference line, Axis
upvoted 5 times
...
AzureJobsTillRetire
1 year, 11 months ago
Box 1: an average reference line With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane Box 2: Axis The question is about drill-down and not drill-through. https://radacad.com/drill-down-and-up-in-power-bi-explained "For example, in the visual below I have SalesAmount as the Value of the column chart, and the Date field (OrderDate) as the X-Axis. Date hierarchy in a Power BI visual This will lead to seeing drill down/up buttons on the top of the visual (or at the bottom of it if the visual is touched at the very top of the report)"
upvoted 7 times
...
Mati_123
1 year, 11 months ago
A and C -- For drill down Axis should be used
upvoted 2 times
Mati_123
1 year, 11 months ago
I mean the answer should be: An Average reference Line Axis
upvoted 2 times
...
...
lukelin08
1 year, 12 months ago
correct answer is - An Average reference Line - Axis
upvoted 4 times
...
rjramyyyy
1 year, 12 months ago
The Answer is C & A, is because for drill down we need to use X-axis, so the answer is axis
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...