Where has the TopN Filter option gone?

Power BI
1

I want to show the bottom N product sales. I have a Rank measure which I have filtered to show where the value is <=50 for my top products. All good. But I can’t see how you filter on Bottom N! I am sure this is an option somewhere…

Contoso - Rank Question.pbix (4.4 MB)

4

@jamie,

Another way to do this is to create a reverse version of your measure, just substituting ASC for DESC and then filter top 50 on that.

image
image980×556 82.1 KB

  • Brian
5

That’s great, thank you Brian. I will do that.

6

Hi @Jamie

Please check this post for Dynamic selection of TopN or BottomN