Forum Discussion
How to add Multiple TopN to a single visual? (Either using a filter or the function)
Here is the scenario There are Fruits and Sub fruits being collected from various farms and this needs to be visualized in a table. Below is a sample of the table. Fruit Farm Value Sub...
amitchandak
Super User
Super UserRefer: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
or
Try category or sub-category rank
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale