Forum Discussion
anuragccsu
1 year agoFrequent Visitor
Filters pane doesn't work as expected
I'm trying to find the top 5 selling products for each store in each location. Initialliy i added, location, store and product and a [Total Sales] measure in the matrix visual and applied the TOPN f...
- Anonymous1 year ago
Hi, anuragccsu
You can populate the Product and Sales fields into the table visual object and then sort the fields in descending order based on the Sales field, where you can see that the Top 5 filtered fields in the matrix are the same as the top five fields in this table visual object. That's why Top N doesn't work.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
elitesmitpatel
1 year agoSolution Supplier
Please share the Dummy PBIX file for easy reference.