cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pandra801 Frequent Visitor
Frequent Visitor

Newbie question about the Top N filter

Hi all,

 

Very new to this but catching on quickly. What a great product.

So, if I ask a simple question:

 

I have a table visual in a report that lists 200+ rows of basic sales data: Company, Product, Revenue. I want to only show the top 10 rows that have the highest Revenue values. Problem is, the Top N filter is not available in the Revenue filter dialog. I see it in other fields though.

 

Why is that, and how would I accomplish this simple task?

 

thanks in advance!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Newbie question about the Top N filter

@Pandra801 What you want is to use either Company or Product and set the TOP N on one of those filters. Then the Revenue goes in the "By Value" field.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Newbie question about the Top N filter

@Pandra801 What you want is to use either Company or Product and set the TOP N on one of those filters. Then the Revenue goes in the "By Value" field.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Community Support Team
Community Support Team

Re: Newbie question about the Top N filter

Hi @Pandra801,

 

As Eno1978 said, you should ensure the "Revenue" column is a value field, if it doesn't a value field you should change its type or use math function(such as count) to convert it.

Capture2.PNG

 

In addition, you can also try to use dax top n function.

 

Table = TOPN(10,Sheet1,[Revenue],DESC)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Pandra801 Frequent Visitor
Frequent Visitor

Re: Newbie question about the Top N filter

Eno1978 - thank you for the reply. Makes perfect sense.

Pandra801 Frequent Visitor
Frequent Visitor

Re: Newbie question about the Top N filter

v-shex-msft: Thanks for the tip, now that I think about it this likely has to be done as well. In any case, thanks for the reply - much appreciated!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)