Newbie question about the Top N filter

[Pandra801]

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!

[v-shex-msft]

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.

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

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

Regards,

Xiaoxin Sheng

[Pandra801]

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!

[Seth_C_Bauer · Accepted solution]

@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.

[Pandra801]

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