cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate 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

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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors