Forum Discussion

anuragccsu's avatar
anuragccsu
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 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 Team

     

    If 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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, anuragccsu 

Thanks for elitesmitpatel and NordicDrow replies. Unfortunately, it didn't reproduce your problem, you can provide the pbix file without sensitive data for testing. Feel free to help you.



Best Regards,
Yang
Community Support Team

anuragccsu's avatar
anuragccsu
Frequent Visitor
1 year ago

Anonymous, elitesmitpatel, NordicDrow please find the sample file. Refer the different workbooks for my experiment and one of them contains the solution using DAX.

The intent to share this file is to brainstorm and find a detailed root cause and working of the great BI product - Power BI. Help me enlighten with your knowledge and share your thoughts.

I can't upload files here as no access probably being a newbie to this community, however i've placed the file a g-drive link for you / anyone interested to debug / learn more about this problem:

https://drive.google.com/file/d/1gS6GBAaGXvGU4TJ35jQ6Eq1QWIkbWX2e/view?usp=sharing 

Please refer the post messages to understand the problem and revert in case of any clarification is required.