Bottom 10 returns too many values

[Anonymous]

Hi,

I have a problem with a table which is returning more values than expected. I have created two tables using filters: Top-10 and Low-10. In filters I have selected Show items Top 10 / Bottom 10. Both tables are working fine until the Low-10 (Bottom) table returns multiple zero values. 

Like this:

Name     Measure

Name1    0

Name2    0

...

Name19  0

Name20 -1

Name21 -1,5

Instead of 10 values it returns all the identical values.

Could this be fixed somehow?

Thanks!

[v-qiuyu-msft]

Hi @Anonymous, 

Is it possible for you to share the pbix file with us? If it is, please remove sensitive data in the report and upload the pbix file to OneDrive, send the share link to me via private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft,

Thanks for your time - I just shared the PBI-file with you.

Greetings,

Anne 

[v-qiuyu-msft]

Hi @Anonymous, 

What you got is expected. You can rank the measure values in ascending order to see there are many 0.00 besides bottom 4 values (negative numbers). I will share the updated pbix file with you in private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Thanks @v-qiuyu-msft, this was helpful!

Greetings,

Anne