Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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!
@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.
Eno1978 - thank you for the reply. Makes perfect sense.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |