Skip to main content
Microsoft Idea

Power BI

Planned

Vertical and horizontal multiples (Small Multiples/Trellis)

Vote (984) Share
Alexander Lyskovets's profile image

Alexander Lyskovets on 14 Sep 2015 20:22:51

As it is realized in Power View for Excel. THNX!

Administrator on 17 Dec 2020 21:56:39

This was just released in preview: Announcing Small Multiples (preview) | Microsoft Power BI Blog | Microsoft Power BI

Comments (106)
Alexander Lyskovets's profile image Profile Picture

Josh Nugent on 16 Aug 2020 03:53:57

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

Agree using trellis views provides a great way of charting against a common axis. Tableau does it beautifully.

Alexander Lyskovets's profile image Profile Picture

Rusty Frioux on 16 Aug 2020 03:53:55

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

Small multiples is essential - you cannot compete without this feature.

Alexander Lyskovets's profile image Profile Picture

Rui Quintino on 16 Aug 2020 03:53:41

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

maybe a cool mode of using this would be a new section available for most charts, like the new tooltip added recently (all visuals benefitted) We could drag& drop fields on the new area, and it would create multiple chart based on that field. Also adjust series options (global, per chart) ,etc.

One of the two last features I really do miss from PowerView, slicer search & multiple charts.

Alexander Lyskovets's profile image Profile Picture

Mike Honey on 16 Aug 2020 03:53:27

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

this is a widely used and very powerful feature in Tableau - currently its a key differentiator

Alexander Lyskovets's profile image Profile Picture

Mall on 16 Aug 2020 03:53:11

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

BIG upvote! Very handy visual for comparison! MUST HAVE!

Alexander Lyskovets's profile image Profile Picture

Lauren Luttrell (SHE/HER) on 16 Aug 2020 03:53:01

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

Add ability to add a "group by" field to reports that will create small multiples for a graph. For example, if I add 'Customer Category' as the group by column, a separate graph will be created for each 'Customer Category.' Currently, I can copy graphs and filter to one, but when the number of categories increases, I have to manually add a new graph. Also, when users filter for a subset, the graphs won't update correctly.

Alexander Lyskovets's profile image Profile Picture

Brandi Malaske on 16 Aug 2020 03:52:58

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

This tool would be very useful. Please vote!!

Alexander Lyskovets's profile image Profile Picture

Power BI User on 16 Aug 2020 03:52:53

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

hardly any votes, why, multiples are needed for great dashboards!

Alexander Lyskovets's profile image Profile Picture

Power BI User on 16 Aug 2020 03:52:50

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

Hardly any votes, amazing. I think this is a must have!

Alexander Lyskovets's profile image Profile Picture

Mark Wilcock on 16 Aug 2020 03:52:35

RE: Vertical and horizontal multiples (Small Multiples/Trellis)

Would be extremely useful. For example, if I have several series (say n lines of different colours) on a time-series chart, this looks cluttered and difficult to differentiate lines. Much clearer if I have n charts each with a single line on the chart. Even better when I want to need to show two related lines per chart/category. This is very common requirement value vs moving average or actual bvs budget, usage vs limit..

Charts could be stacked side-buy-side (horizontal), directly below each other (vertical) or could simply wrap (side-by-side to page width then next row). We weed a new "Multiples" option in the properties well of most chart types that takes values: Horizontal, Vertical, Wrap.

This was in Excel's PowerView and small multiples are a basic staple of data visualisation techniques.