I want to use the visual filters to produce Top 5 but since there are many ties visual shows about 20'things'. So, i have used DAX to create a calculated table to create the desired Top 5 visual. Problem with DAX based visual is that drill down doesn't expose records.
so, any way to handle ties in the visual level filters?
If there is a tie, in order_by values, at the N-th row of the table, then all tied rows are returned. Then, when there are ties at the N-th row the function might return more than n rows.
I don't think there is an option to change this default behavior for TopN filter in Power BI currently. And I also cannot find a alternative way in this scenario. So I would suggest you add it as an idea on Power BI Ideas to improve Power BI on this feature.
@v-ljerr-msft Since my opening post wasn't clear what the issue was without a demo will you please suggest a problem statement that will resonate with others? I will then post to the suggestions forums.
thanks @Dennes, helpful for DAX based top 5. I am glad to see how it is done in DAX/with Summarize, althought this post was about handling ties in the desktop. Drawback with DAX/Summarize method is that drill down in the Data/Drill tab will not return much meaningful granular data. For this reason would like way to handle ties using visual level filters.