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 😁
Blog Post/PBIX:
https://bielite.com/blog/small-multiples-sorting-pagination-power-bi/
Previous Small Multiples Video:
https://www.youtube.com/watch?v=fktQmk0a9OI
To enroll in my introductory or advanced Power BI courses:
https://training.bielite.com/
Elite Power BI Consulting:
https://bielite.com/
Data Insights Tools:
https://www.impktful.com/
Connect with me on Twitter!
https://twitter.com/PowerBIElite
0:00 Trick Intro
2:16 Custom Sorting
6:40 Adding Pagination