Forum Discussion

hxkresl's avatar
hxkresl
Icon for Advocate III rankAdvocate III
9 years ago

TopN ties: handling ties when using visual level filters

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. Pro...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi hxkresl,

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. :smileyhappy:

 

Regards

hxkresl's avatar
hxkresl
Icon for Advocate III rankAdvocate III
9 years ago

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.