Hi, I hope you could help me with this one!
I created a new column to rank categories according to sales, since I wanted to show our top 10 categories. It worked fine in the table.
However, when I try to build a visualisation table, it only returns some of the ranks, as you can see:
How can I solve this? I have zero filters working, by the way!
Thank you!
Silvia
Hi. Yes there are two ways to solve this.
In the filter pane under categories you should find that there is a "TOP N" filter. You can use that for a visualization.
Just add the value and the number of the ranking categories.
Other way and the most difficult is creating a measure instead of a column like this site suggestion:
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi. Yes there are two ways to solve this.
In the filter pane under categories you should find that there is a "TOP N" filter. You can use that for a visualization.
Just add the value and the number of the ranking categories.
Other way and the most difficult is creating a measure instead of a column like this site suggestion:
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
