This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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