Notifications
Clear all
Topic starter
22/08/2022 1:53 pm
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.
Suggested Answer:
Explanation:
Graphical user interface
Description automatically generated with low confidence
Box 1: Top N
Scenario: 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.
Once you drag to SKU to Visual level filter you should get Top N option
Note: The two most common filter types: automatic and manual.
Then there are more advanced filters.
Box 2: Visual
Once you drag to SKU to Visual level filter you should get Top N option.
Reference: https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/