small multiples dynamic grid - with no scrollbar

[Mmahachi]

I've searched all the small multiples post and cannot find a solution. Im using small multiples with the 100% stacked column chart and in order to avoid a vertical scroll bar within the visual I needed to set the rows to 5, the number of categories for my small multiples range from 2 to 10. so when its the 10 categories it looks great but when I select one of the 2 categories it shows 4 blank rows. How can I get rid of these blank rows??

[Ritaf1983 · Accepted solution]

Hi @Mmahachi 
Unfortunately, this is the way it works.
Small multiples are very static viz.
Please vote for the linked idea  (I voted :)):
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=f2b26341-642d-ee11-a81c-000d3ae68319

As an alternative consider using a matrix with conditional formatting something like, but with a matrix 

Link to download a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly