cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to Use Vertical/Horizontal Multiples in PowerBI

I am aware that MS Excel 2016 Power View has handy feature of Vertical Multiples and Horizontal Multiples.

 

Here is sample output. How to implement this in PowerBI. Cannot find this feature anywhere.

 

Plz don't tell me we have to manually create pie chart for each month and then pin to dashboard ....

enter image description here

3 REPLIES 3
Highlighted
Anonymous
Not applicable

Re: How to Use Vertical/Horizontal Multiples in PowerBI

Unfortunately, this feature doesn't exist in Power BI.

 

However, for a dashboard design perspective, you may want to consider not using 12 pie charts.  I would recommend 2 visuals:

1) A column chart with Month on the X axis and your measure on the Y axis

2) A pie chart (or probably a bar chart) with whatever you're breaking each month up by on the y axis and your same measure as the value.

 

This also has the benefit of using less screen "real estate".

 

That way when the user is in Report View and clicks a single month, the cross-filtering will update the pie/bar chart to show how that month is broken out.

 

Asking a user to compare 12 pie charts simultaneously will likely result in confusion, not insight.

Highlighted
Microsoft
Microsoft

Re: How to Use Vertical/Horizontal Multiples in PowerBI

Hi @QQQ,

 

Please vote this idea: vertical-and-horizontal-multiples-small-multiples. Maybe we can have it soon. 

 

Please mark @Anonymous's answer as solution if it's convenient for you.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: How to Use Vertical/Horizontal Multiples in PowerBI

You killed me with that graph friend  😞

The only option I know nowadays is doing it with R script and ggplot2 library:

https://community.powerbi.com/t5/R-Script-Showcase/MultiChart-Vertical-Multiple-Charts/m-p/75449

hope it helps Man Happy

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors