Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 11 question 1 discussion

Actual exam question from Microsoft's PL-300

Question #: 1
Topic #: 11

HOTSPOT -
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Top N -
The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

Box 2: Visual -
The reports must show historical data for the current calendar year and the last three calendar years.
Applying specific measures to the visual-level filter of a visualization is a very powerful technique to completely customize the items shown in a report. The presence of this filter requires special measures in order to display values related to items not included in the visual level filter.
Reference:
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

by fdsdfgxcvbdsfhshfg at Sept. 18, 2022, 9:33 p.m.

Comments

Submit Cancel

PinkZebra

Highly Voted 2 years, 1 month ago

TopN Visual (TopN is a visual specific filter)

upvoted 54 times

Lavoisier

1 year, 3 months ago

It is not true... TOPN can be applied on Visual, Page or Report level... In this case, it is on the report

upvoted 3 times

SteveTheBeast

1 year, 3 months ago

Just tested it. TOP N only works on a visual. The option doesn't appear in Page or Report filtering.

upvoted 21 times

...

MauDV

Highly Voted 2 years, 2 months ago

Since it's talking about Top Customers Report, I would assume all of the report is based off the top customers, so shouldn't box 2 be Report level?

upvoted 11 times

Joe75

2 years, 2 months ago

You can't use TopN in report or Page level

upvoted 18 times

ArtJC

1 year, 6 months ago

Correct is TopN on Report Level, as required. You apply filter on filter pane, where you can set it per Visual/Page/Report level !

upvoted 3 times

bdub1976

11 months, 4 weeks ago

Negative. Your options in PBI are filter on visual, page or all pages. While technically all pages could be considered at the "report level," you still can only add a TopN filter at the visual level. Period, end of story.

upvoted 2 times

...

SylUK

Most Recent 3 months, 3 weeks ago

TOPN and VISUAL are the correct answer. The Top N filter is applied at the visual level, meaning it only affects the data displayed on a specific chart or table.

upvoted 1 times

...

MoneyStacking

7 months ago

Passed with 917/1000 Question and answers were exactly the same but different order with the options! Answer given: - TopN - Visual

upvoted 9 times

...

b7c21a9

8 months, 1 week ago

28-Mar-24 - This Q came up

upvoted 4 times

...

Dani_eL

8 months, 3 weeks ago

Requirement is to build 3 reports. Top Customer report description only include Top customers and nothing else. So it seems legit to put the filter at report level. Furthermore, if you need to pin the report in a dashboard instead of the visual, you 'll get the filter too

upvoted 1 times

Dani_eL

8 months, 3 weeks ago

my bad... there is no Top N at report level but at visual there is

upvoted 1 times

...

madyjoe21

10 months ago

It is possible use TopN filter in report and page level. Please, check this video: https://www.youtube.com/watch?v=4N-KocuYyNU

upvoted 2 times

...

jl234

1 year, 1 month ago

As it mentioned "The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.", I believe that the TopN filter should be applied on "Report level". If it is applied on visual level, only specific visual will be affected, but not the "selected order month or quarter, product category, and sales region" on the report.

upvoted 1 times

...

lukelin08

2 years ago

Given answer is correc TopN Visual (TopN is a visual specific filter)

upvoted 5 times

...