cancel
Showing results for 
Search instead for 
Did you mean: 

Bottom 10 returns too many values

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!

Status: New
Comments
Moderator

Hi @annela

 

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 

Occasional Visitor

Hi @v-qiuyu-msft,

 

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

 

Greetings,

Anne 

Moderator

Hi @annela

 

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 

Occasional Visitor

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

 

Greetings,

Anne