Is there any way to maintain a “Top N” filter so that when drilling through the hierarchy, you only see the top N number of rows? In the attached example, I have a matrix with County and the user can drill down to city. I set a filter to top 5 counties, but when a user drills down to city, I would like them to see the top 5 cities. Applying a top 5 filter to city doesn’t work because then only the 5 cities are included when viewing by county.
The reason why I want this functionality is to limit the amount of rows in a table so that a very long list of rows doesn’t take a long time to load.
Free training Power BI Demo.pbix (506.1 KB)