Bottom N without blanks and zeros

[Anonymous]

Good morning all,

I have a measure that is a ratio between the sum of two columns and with this measure I want to give the top 5 and bottom 5 values. I have no problems with the TOP 5, although, I have several examples that this ratio is 0, so when I want to get the 5 bottom values, power bi gives all the zero values. I've applied another filter in order not to show the zeros, however I have to change my bottom 5 to bottom N, in order to get the lowest 5 values that I want to be represented.

Is there any possibility get the bottom 5 values that are bigger than 0 and not have to fix mannually the BottomN?

Thank you so much for your help

Best regards

[Anonymous · Accepted solution]

Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'

[Anonymous]

Perfect! Thank you so much