How to Use Vertical/Horizontal Multiples in PowerBI

[QQQ]

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 ....

[Anonymous]

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 

[v-jiascu-msft]

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

[Anonymous]

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.