Ranking not working!

[Anonymous]

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

[ibarrau · Accepted solution]

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.

Top N

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.

[Anonymous]

Thank you, I used the first solution and it worked! 🙂