Forum Discussion
Ranking not working!
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.
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.
Thank you, I used the first solution and it worked! 🙂