Pragmatic Works Nerd News

Power BI: Small Multiples Visual Preview

Written by Matt Peterson | May 18, 2021

Power BI came out with a new preview feature in the February 2021 version of the Power BI Desktop known as small multiples. To use this feature as of the May 2021 release, you need to turn on this feature in your preview features.

The small multiples feature allows you to take a bar/column, line, area, or combo chart visual and essentially duplicate the visuals on the page with each one being uniquely filtered down by a specific dimension. For example, you could split a column chart that displays your sales by country into unique duplicates that report for each year.

To create the small multiples you will drag the field that you want to dissect your original visual by into the Small Multiples field in your visualization pane. After seeing the new result, if you want to have even more control of how the visual is display check out the Small Multiple Title section and Grid Layout section in the formatting area of the visualizations pane. From here you can change how many rows and columns display along with quite a few padding features.

Check out this video which will walk you through how to use this new feature.

 

If you enjoy this video or any of my other videos and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" to get 20% off at check out when purchasing our On-Demand Learning classes from https://pragmaticworks.com/pricing/