Power BI TreeMap: Displaying Top 10 Categories with Dynamic Updates

[Gamze]

I'm using a TreeMap in Power BI to track costs related to my import operations under 26 categories. These data change every month. Viewing all 26 categories at once makes the visualization harder to interpret. Displaying only the Top 10 categories would be sufficient.

However, if I manually exclude the remaining 16 categories from the dataset, any data that might fall into the Top 10 in future months will be excluded from the visualization.

How can I dynamically display only the Top 10 categories without losing the ability to account for all 26 in future months?

[lbendlin]

Impossible with a treemap visual.  Top 10 has different meanings across different months.  Keep including all items. The Treemap allows you to visually identify the top items - that's its purpose.

If you want to compare ranking across months use a Ribbon Chart.