Ready to curb your Power BI skills? Find out more here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.


Dynamic TopN + Others in Power BI

It is very useful and common practice to be able to group data in Power BI by the, for example, top 5 and then group the remaining categories in a new category called Other.

Unfortunately, Power BI does not have this capability so we need to recreate it manually.
Let me show you here one way to do it.

Watch the tutorial:

DAX Fridays! #132: Dynamic TopN + Others in Power BI

Links to the mentioned resources

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #132

Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents