Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
in Power BI by 11 11 15

In power bi, I imported an Excel sheet about countries and profits I want to display only the top 5 countries in the bar chart. how I can do that?

Show only top 5 countries in power bi bar chart


1 Answer

1 like 0 dislike
by 16 25 39

Filter by top N in Power BI

In Power BI desktop, to show only the top 5 countries you can set Filter type to Top N in the filter pane:

  1. Select the visualization and expand the filter pane
  2. Expand country field and select Top N from filter type then add the value of show items
  3. Add a field that you want to filter by in this case the field is Country and click Apply Filter
    Filter by top N in Power BI

Check Also, 4 different ways to get Top 10 in Power BI

If you don’t ask, the answer is always NO!