Power BI - Dynamic Categories in the Small Multiples Visual!

Microsoft has just released the Small Multiples functionality within Power BI! This visual is amazing on its own, and is even cooler with this trick you are about to watch. In this video, we learn how to make the categories within the Small Multiples chart dynamic via slicer selection!
To enroll in my introductory or advanced Power BI courses:
training.bieli...
Blog Post/Download PBIX:
bielite.com/bl...
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite

[@abhishekstatus_7]

Thanks for the explanation Parker ! This is really great but it has one disadvantage that we cannot use Smart narratives based on the Smart multiple visuals !! Rest assured its really great to have this in Power BI which Microsoft power bi team has provided!!

[@deolamitico]

omg it worked. thank you so much I spent hours trying other things. this is the only one that worked. its beautiful

[@faropebr]

Hi, Parker! Thanks for sharing!

[@grinkorable]

But what if I want a dynamic grid layout?. For example: I want the year to be my small multiples, but at the same time, year is a filter for all pages, so....If the user wants to filter the year 2022, I want my grid layout to be 1x1. But, if the user checks year 2022 and 2021, the layout should be 1x2, and if the user checks 4 years, then the grid layout should be 2x2, etc, etc...Is this even possible?.

[@jrazafindrabe5229]

WOW ... My Jaws Dropped ... Thanks Parker and have a blessed new year 2021.

[@BIElite]

You too J Raz :)

[@davepoppenhouse4459]

Great stuff Parker. Thanks much!

[@BIElite]

Thanks Dave!

[@anshumansingh3585]

Parker -- A great trick.. thanks and stay blesssed..

[@BIElite]

You too Anshuman!

[@johniverson9745]

This is a huge help! I have a follow up question though. I'd like to add a second slicer that would let me switch from something like sales in dollars to sales in pieces. How could I combine that with what you showed?

[@rauljimenez5485]

@John, I would incorporate that into the base measure (in this case the [Total Sales] measure he used). Develop that measure to return the value based on the currency slicer chosen)

[@mcnater]

Awesome stuff as always. Appreciate it!

[@BIElite]

Thanks for the watch, Nate!

[@nurholis5045]

Thank you very much. Simply awesome

[@JW-ho9hg]

What needs to be done for selections in the small multiples table to filter other visuals on the report page?

[@azzamsiddiqui9510]

This is brilliant.

[@archimittal1529]

How can I download the dataset shown in the video

[@vyasrahul]

Can this is be applied to a situation where for example. In my table I only have Date, cost, and expense. I want to put a dynamic slicer as a gross margin from (10-99%) so when I select the margin it automatically gives me the Sales columns? ( Cost + Expense) * Margin = Net Sale price.

[@chrismiller1317]

great content! the image of your screen is a little grainy but still good.

[@BIElite]

Aw man, I'll have to look into that. Thanks for the heads up!

[@stevenpcopley]

Fantastic, thank you.

[@markedralin9776]

I tried this but the filters are not working. Did I miss anything?

[@distrilanalytics]

How to get small multiples. Here at my power bi desktop there's no option?

[@r.khatiwada1549]

Awesome!

[@totvabe1]

Great!

[@paplight]

what i have to do to enable it?

[@BIElite]

Enable Small Multiples in the preview features. Information here: powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831297