Skip to main content
Microsoft Idea

Power BI

New

Enable dynamic columns in small multiples

Vote (12) Share
Daniel Sprague's profile image

Daniel Sprague on 06 Aug 2021 11:07:02

Yes, of course we can change the number of columns in small multiples.  But it has to be hard coded.  It would be very beneficial to set the number of columns dynamically, using a measure.  



This would enable the end user to pick the items they wanted to compare, side by side, dynamically.  For example, if a user wanted to compare sales for years 2019 and 2020, and they pick those years in a slicer, Small Multiples would show 2 columns, 2019 and 2020 side by side, for easy comparison and analysis.  If the user picked 3 years, they would see 3 columns side by side.

 

Comments (1)
Daniel Sprague's profile image Profile Picture

ANDRE PEREIRA WALTER on 21 Dec 2022 17:51:00

RE: Enable dynamic columns in small multiples

For shure this would be very useful