In this Power BI tutorial, you’ll learn some advanced formatting tricks for small multiples visuals. By default, you are only able to sort small multiples by the name of the item in the small multiples field. With this trick, you’ll be able to sort via any calculation or logic you would like to apply.

After we cover the custom sorting, we quickly learn how to set up pagination on the visual. I tend to like “pages” of visuals as opposed to a scrollbar when too many items overflow the visual. You can apply this to any visual you want, though it looks great with small multiples visuals 😁

Download PBIX

I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!


Parker Stevens

Parker is the creator of the BI Elite YouTube channel, a community of over 30,000 students learning Power BI, DAX, and Power Query. He is a Microsoft Data Platform MVP for his work with Power BI and continues to provide elite Power Platform training courses to help data analysts, BI developers, and citizen dashboard creators reach their goals. Parker is committed to producing high-quality training content that is also extremely cost-effective, to ensure that the largest amount of users can benefit from the content. Training courses located at https://training.bielite.com/