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.
Hello,
I am trying to display the Top 5 gifts by gift amount in the table below, but I am not able to get a Top N filter to work? The visual level filters for my gift amount field (formatted as a decimal number) do not give me the Top N filter option. Also, I have seen this thread about top N filter for a measure, but the gift amount field is not a measure? Any ideas? I want to use this in conjunction with a year filter so users can easily see the top 5 gifts each year.
Solved! Go to Solution.
I really want to know what kind of gig you have going. I wish I had the problem of figuring out who gave me $4M and $2M versus a measely $1M. 🙂
See image below on Top N filter, it is working for me. Your issue might be that you have ties. If you have ties, TOP N treats those as the same "rank" if you will so you can end up with more than you specify.
I really want to know what kind of gig you have going. I wish I had the problem of figuring out who gave me $4M and $2M versus a measely $1M. 🙂
See image below on Top N filter, it is working for me. Your issue might be that you have ties. If you have ties, TOP N treats those as the same "rank" if you will so you can end up with more than you specify.
Thanks @Greg_Deckler! I needed to add the gift amount filter in a second time and not use the one that was automatically included when I added that field to my visual.
I do have a pretty good gig going though .
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |