TopN only returning 1 result against decimal values
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.
4 Comments
v-cazheng-msftCommunity Support
Status changed:NewtoInvestigatingHi 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
- v-cazheng-msft
Hi Anonymous,
Thanks for your reply! Got it.
Best Regards,
Community Support Team _ Caiyun
- v-cazheng-msftStatus changed:InvestigatingtoDone
Issue was caused by the filter on a field.