ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 11 question 1 discussion

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

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
PinkZebra
Highly Voted 2 years ago
TopN Visual (TopN is a visual specific filter)
upvoted 53 times
Lavoisier
1 year, 2 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, 1 month ago
Just tested it. TOP N only works on a visual. The option doesn't appear in Page or Report filtering.
upvoted 20 times
...
...
...
MauDV
Highly Voted 2 years, 1 month 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 ago
You can't use TopN in report or Page level
upvoted 18 times
ArtJC
1 year, 5 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
10 months, 2 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 2 months, 1 week 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
5 months, 3 weeks 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
7 months ago
28-Mar-24 - This Q came up
upvoted 4 times
...
Dani_eL
7 months, 2 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
7 months, 2 weeks ago
my bad... there is no Top N at report level but at visual there is
upvoted 1 times
...
...
madyjoe21
8 months, 3 weeks 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 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
1 year, 11 months ago
Given answer is correc TopN Visual (TopN is a visual specific filter)
upvoted 5 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago