.svg){kind=icon}
.gif)
.svg)
Quick summary
The Top N filter in Power BI lets you limit a visual to show only the highest-ranked items based on a chosen measure. Using the Filter pane, you can configure this in seconds without writing any DAX or custom code.
Steps
- Launch Power BI Desktop and select a data source to load your data.
- Make sure you have a visual on the canvas and click on it to select it.
- Open the Filter pane on the right side of the screen.
- Drag the field you want to filter by into the Filters area.
- Set the Filter type to Top N.
- In the Show items field, select Top and enter 10 as the count.
- In the By value field, drag the measure you want to rank by.
- Click Apply filter to confirm your settings.
- Your visual will now display only the Top 10 items ranked by your specified measure.
