Forum Discussion
Filters pane doesn't work as expected
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
community, Though i seem to solve it using DAX but i was really not able to comprehand the results of filter pane TOPN(5) filters as shared in my first comment of this topic. This was without DAX.
Filter -> Group -> Summarise is a general flow for any analytics query. Had that been followed here then the results would be same as DAX approach. I did a little research and found some information from MS Learn Power BI documentation:
https://learn.microsoft.com/en-us/training/modules/power-bi-effective-filters/2-report-structure
as it says
| Unlike report and page-level filters, a visual-level filter can filter by using a measure. When a measure filters a visual, it's used to eliminate groups. Fo example, consider a column chart visual that groups by store. A measure filter could eliminate groups (stores) where the total store sales are less than a certain amount. |
Very cryptic language and "Could". I think this can be suggested to Microsoft as enhancement.
Having said that all i'm still not able to comprehand the output by matix visual using the filter pane TOPN filter. For any curious reader, who'd like to explain how top5 were selected by the visual from all products at right to top5 in left:
Anyway i think after referring to MS Learn doc, i can sleep peacefully today 😀
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 TeamAnonymous, 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.