Forum Discussion
small multiples dynamic grid - with no scrollbar
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??
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-000d3ae68319As 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
1 Reply
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-000d3ae68319As 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