Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
This one is a bit tricky but solves a common wish of showing af table with the Top number of x plus others.
There are several tricks involved in this one - first we use a matrix and add the numeric fieldparameter value to the rows and then the attribute we want to group the items by - hide the +/- icon and then we use different visual calculations to show the attributes value if is matches the rank number of the product.
Visual calculation functions used:
EXPAND
RANK
ISINSCOPE
RUNNINGSUM
A large dataset will affect the performance and you might want to consider alternatives
Enjoy visual calcs
Erik