Skip to main content

Power BI

Needs Votes

Vertical and horizontal multiples (Small Multiples/Trellis)

Vote (893) 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!

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

9d1909b8 9acf-ea11-a812-000d3a8ddfb2 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

8281c818 753e-4c50-a869-2b93f5c1f590 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

223102fb dfb1-4094-b38f-ec3e2b47f2b0 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

5526a02f f978-47f9-853d-6f82602e0a16 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

710f0fd7 9ee3-4ddc-9830-b02f3d8a88e8 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

710f0fd7 9ee3-4ddc-9830-b02f3d8a88e8 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

8afc5134 1879-4728-8e1a-7f7ad4edee4f 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.

Alexander Lyskovets's profile image Profile Picture

ba4ca124 ff6d-44cf-ad41-77c2898201af on 16 Aug 2020 03:52:01

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

Why would you remove this? Ball is dropped!

Alexander Lyskovets's profile image Profile Picture

76a17fb5 d6c5-ea11-a812-000d3a9b112e on 16 Aug 2020 03:51:59

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

The Header was supposed to be called "small multiples" instead of Smalltalk...

Alexander Lyskovets's profile image Profile Picture

d167feaf e062-4af9-9785-428d36bc7cda on 16 Aug 2020 03:51:59

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

When showing this fuctionality in Power view in Excel,it is one of things that creates the most interest for adoption. It really is an outstanding feature :)