How to display only top 5 countries in Power BI?

Question

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?

 

Answer 1

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:
Steps

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