Display Top N and group remaining categories into an “Other” bucket so totals remain accurate

[SinghArchana]

Currently in Power BI we can apply a Top N filter on visuals to display the highest categories based on a measure. However, when Top N is applied, all remaining categories are removed from the visual, which means their values are not represented.

Because of this behavior, the total shown in the visual may not represent the full dataset, as the remaining categories are excluded after the Top N cutoff.

It would be very useful to have a native Top N + Other option in Power BI visuals.

With this feature, the visual would display:

• Top N categories based on the selected measure

• An additional “Other” category that aggregates all remaining categories

This approach would ensure that:

• The full total is preserved

• The visual remains clean and readable

• Users can focus on the most significant categories while still including the rest of the data