Forum Discussion
Ranking not working!
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.
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.
2 Replies
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.