Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 18 discussion

Actual exam question from Microsoft's 70-779

Question #: 18
Topic #: 1

DRAG DROP -
You create the PivotChart shown in the exhibit. (Click the Exhibit button.)
Exhibit:

In which area is Product and in which area is SalesAmount? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

by JohnFan at Oct. 7, 2019, 12:24 a.m.

Comments

Submit Cancel

Aurelkb

Highly Voted 5 years, 8 months ago

Answer is correct i test it. Axes and Values

upvoted 23 times

ammu

5 years, 7 months ago

Correct answer is Legend and value, when you create any pie chart axis and axes will get disabled in chart element.

upvoted 2 times

Shil

5 years, 6 months ago

In power pivot, it is the Axes and Values where as in Power BI, it is Legend and Value. So based on the question, the answer, Axes and Values is Correct.

upvoted 13 times

...

SN22

5 years, 4 months ago

I agree

upvoted 2 times

...

hfgirona

4 years, 7 months ago

IS total Correct, I tested.But you must put SalesAmount field and the Chart is UnitsSold... Don't know...

upvoted 1 times

kwmmss

4 years, 5 months ago

Agreed, it's weird that the Chart says UnitsSold. I think it's Axis and no selection

upvoted 1 times

...

JohnFan

Highly Voted 5 years, 8 months ago

Correct answer is Legend and Values.

upvoted 18 times

Daviddy

5 years, 5 months ago

As Aurelkb and Shil mentioned, Axis is the correct answer. In my test, legend does not give you the same result in PivotChart.

upvoted 3 times

...

jason69

4 years, 6 months ago

I thought the same initially, but then tested it. In a pivot chart, which is a pie chart, it is "Axis" and "Values". If you use "Legend" instead of "Axis", the chart does not display correctly.

upvoted 1 times

...

P_S09

Most Recent 4 years, 7 months ago

its axes, this is a trick question. Pie Charts are built differently. We all would think it would be legend and values, but in a pie chart its axis.

upvoted 1 times

...

osaid

4 years, 8 months ago

Axis and Values. I tested it.

upvoted 1 times

...

Waltmas

4 years, 11 months ago

Tried it out its actually axis and values

upvoted 1 times

...

Agustin

5 years ago

Tested it: It is Axis and Values. How do you test this. You create a Table, then you create a Pivot. You click on the Pivot and Create the Chart. That will allow you to choose where you put "Products". When you put "Products" in the Axis columns you get the same graphic as in the question. When you put it in Legend, it simply does not work.

upvoted 1 times

...

sumitmalik

5 years ago

". Not all visuals have axes. Pie charts, for example, don't have axes. " https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis

upvoted 1 times

Nastja

4 years, 5 months ago

But this is about Power BI

upvoted 1 times

...

Outsider

5 years ago

It is a Pivot Chart. Pie chart came from a Pivot Table. So, product should be in Axis. It is Axis and Values. Test it.

upvoted 5 times

Eric777

5 years ago

Outsider - I tested it. You are correct.

upvoted 1 times

...

CibrevN

5 years ago

Axis or Legend? What is correct?

upvoted 2 times

ikenigs

4 years, 12 months ago

Against common sense, the correct one is Axis and NOT Legend. Had to test it to beleive it.

upvoted 3 times

...

123

5 years, 1 month ago

Can you add Axis titles to a pie chart? "After you create a chart, you can add axis titles to the horizontal and vertical axes in charts that have axes. You **can’t add them to charts that don’t have axes such as pie and doughnut charts**. Much like a chart title you can add, axis titles help the people who view the chart understand what the data is about.. Add axis titles to a chart - Excel support.office.com/en-us/article/Add-axis-titles-to-a-char… I'd say "legend" is the correct answer

upvoted 1 times

...