TopN only returning 1 result against decimal values

[Anonymous]

I have a matrix visualization that contains a list of items and their percent of increase since the previous month.  When I try to filter for the Top 5 items based on that percent of increase, it only shows the very first item.  The same behavior occurs when the increase field is formatted as a regular decimal.  The same behavior occurs when using RankX...only displays the first item.

Note, using TopN on regular whole numbers works fine.

Is this a bug or how it is supposed to work?

Using March 2022 version of desktop.

[v-cazheng-msft]

Hi @Anonymous,

I couldn’t repro this issue with the latest version of Power BI desktop(2.104.941.0 64-bit, April 2022). If you still have this issue, please try with it. Here is the link of the newest Desktop: Download Microsoft Power BI Desktop from Official Microsoft Download Center.

If issue still exists after the trial, could you please let me know more details about how you use TOPN/RANK or provide a download link of a sample pbix file that contains this issue? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

You can cancel this issue.  It turned out I had another field that was filtering the data and that was skewing the results.

[v-cazheng-msft]

Hi @Anonymous,

Thanks for your reply! Got it.

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Issue was caused by the filter on a field.