Table of Contents
Yes, it is possible to limit a Power BI chart to display only the top 10 values by using the “Top N” filter feature. This allows users to specify the number of top values they want to see in the chart, making it easier to focus on the most significant data points and identify trends or patterns. This feature is particularly useful when working with large datasets, as it helps to reduce clutter and improve the readability of the chart.
Often you may only want to display the top 10 (or top n) values in a chart in Power BI.
Fortunately this is easy to do by using the Top N visual level filter in Power BI.
The following example shows how to use this filter in practice.
Example: How to Only Show Top 10 Values in Chart in Power BI
Suppose we have the following bar chart in Power BI that displays the points scored by basketball players on various teams:
Currently the chart shows the points scored by all 14 players in our table.
However, suppose that we would only like to display the players with the top 10 points scored.
To do so, click the bar chart to make it active.
Then click the dropdown arrow next to Team under the Filters tab.
Then click the dropdown arrow under Filter type and choose Top N.
Then type 10 under Show items.
Then drag the Points field to to the By value area.
Lastly, click Apply filter:
Once you click Apply filter, the bar chart will be filtered to only show the players with the top 10 points scored:
Also note that you could type any number you’d like next to Show items to show a different number of bars instead.
For example, if we typed 5 then only the players with the top 5 points values would be shown:
Note: To show the bottom 10 values instead, simply click Bottom under the Show items dropdown menu.
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: