How to Create Dynamic Small Multiples in Power BI Without Hardcoding Rows and Columns in Power BI

If you've used small multiples in Power BI, you might have noticed the need to hardcode the number of rows and columns. This limitation can result in blank spaces when the selected categories from a slicer are fewer than the hardcoded amount. In this guide, I’ll show you a workaround that works efficiently. Join this channel membership to get access to all the recorded bites as they become available: Here you can download all the pbix files: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: - Join our DAX Fridays! Series: - Power BI dashboards for beginners: - Power BI Tips & Tricks: - Power Bi and Google Analytics: ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: Contact us: QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► Mastodon ► @ruthpozuelo@ Twitter ► @curbalen Facebook ► #CURBAL #SUBSCRIBE