Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 125 discussion

Actual exam question from Microsoft's 70-778

Question #: 125
Topic #: 1

HOTSPOT -
You have a report in Power BI Desktop 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

Suggested Answer:

by TiaanR at July 10, 2019, 10:32 a.m.

Comments

Submit Cancel

TiaanR

Highly Voted 5 years, 11 months ago

For the Terretory field - it should be added to the visual level filter. If it is added to the Value field, the amount will be replaced by a count of territories.

upvoted 55 times

Hien

5 years, 10 months ago

I agree

upvoted 2 times

MoAsvat

5 years ago

No Visual well in the gauge visual

upvoted 1 times

...

mohroshdy

Highly Voted 5 years, 6 months ago

For the Territory of Canada always -> The visual level filters field To filter Canada territory only

upvoted 7 times

Dirk

5 years, 3 months ago

I have the same problem like CorinnaK...Where is the Visual Level Filter for a gauge visual?? Can't find it there...

upvoted 1 times

Agustin

5 years ago

In the filters pane (left from the visualizations pane) you have Filters. You will find three different level of filters (visual, report, page)

upvoted 2 times

...

FrdFrd

Most Recent 4 years, 5 months ago

Correct Answers: 1) a DAX Formula (be careful: the "Calculated Measure" concept does not exist. A measure you create using DAX is simple "Measure") 2) I would choose "the Visual level filters field", assuming they are refering to "Filters on this visual" part of the "Filters Pane". Besides, neither the Tooltips nor the values field will do the work.

upvoted 1 times

...

JeiLoa

4 years, 6 months ago

Territory should fall into Tooltips field

upvoted 1 times

...

CDL

4 years, 7 months ago

1. we dont see many "measure" for target/budget in the FIELDS list, so we need to manually set up in "Format setting" for Min/Max/Target. 2. add the "Territory" to "Visual Level filters field" (drag and drop, and then select the "Canada" (basic filtering) on the left hand side of "all the visual icon. All tested.

upvoted 3 times

Mar_tin

4 years, 7 months ago

I agree to CDL: 1. Format settings Because there is no entry in the "Target value" it indicates that Target value was set up manually in the Report Section/Visualizations Pane/Format/Gauge axis/Target=90000000. to make sure to get Min=100.00 & Max=200M you enter them manually as well in Report Section/Visualizations Pane/Format/Gauge axis/ Min&Max 2. Visual level filters filed Drag Territory in the Report Section to Filters Pane and select Canada

upvoted 1 times

...

Vermonster

5 years, 5 months ago

Can't be values field because a gauge visual can only have a single value so the territory would have to be added to the visual level filter (also visual level filter would allow selection of Canda). Given the screen shot, the manual entry of the target value using formatting is the only possibility.

upvoted 4 times

...

AlexThoBreaux

5 years, 6 months ago

In the visualization pane click on the format button for the Gauge visual and in the gauge axis you can manually input values for the min, max , and target values.

upvoted 2 times

...

JohnFan

5 years, 6 months ago

The goal is set by using The Format Setting?

upvoted 3 times

AnetaK

5 years, 6 months ago

Yes. It is typed manually.

upvoted 3 times

150oche790

5 years, 2 months ago

please what is the reason for setting the goal?

upvoted 1 times

prokocim

5 years, 2 months ago

To show a goal (line) on a gauge you need a MEASURE and place it in 'Target Value' in Fields Setting. In Format Setting you only hide or unhide the value label.

upvoted 5 times

Tobi999

4 years, 9 months ago

Yes but in the picture the Target-Value-Field is empty, so the goal must be set in the settings

upvoted 2 times

...

CorinnaK

5 years, 8 months ago

Where do I find the Visual Level Filter for a gauge visual?

upvoted 2 times

...