Forum Discussion
Dynamic small multiples grid layout auto‑adjust rows/columns based on number of categories?
Hi everyone,
I have a small multiples chart (line chart) where each small multiple is a vehicle that has temperature readings. I've already filtered out vehicles with no data using a measure (COUNTROWS > 0) in the visual‑level filters, so only vehicles with actual readings show up. That part works well.
My problem is the grid layout. The "Rows" and "Columns" under Format → Small multiples → Grid layout are fixed numbers. So if I set it to 2 rows × 5 columns, but a company only has 4 vehicles with temperature data, I get 4 charts plus a bunch of empty cells/rows.
What I want is a dynamic grid: if a company has 4 vehicles → show 4 charts (e.g. 1 row × 4 columns), if it has 1 vehicle → show just 1 chart, if it has 10 → expand accordingly — without empty placeholder cells. Basically the grid should resize itself based on the number of categories currently displayed.
My questions:
- Is there any native way to make the small multiples grid dimensions dynamic (driven by the count of categories), maybe via a measure or field parameter? So far it looks like Rows/Columns are static format settings only.
- If not native, is there a custom visual / library (AppSource or otherwise) that supports auto‑fitting/flowing small multiples based on the number of categories?
Hi pitscompany,
I think there is no native way to dynamically bind the Rows and Columns properties to a measure or field parameter. In native Power BI visuals, the Grid Layout dimensions for small multiples are hardcoded formatting properties that cannot accept conditional formatting (fx) inputs.
You can look into custom visuals like Deneb that allows you to build custom charts using Vega-Lite JSON specification.
- https://marketplace.microsoft.com/en-us/product/power-bi-visuals/coacervolimited1596856650797.deneb?tab=overview&hl=en-AU
- https://deneb.guide/?hl=en-AU
Let me know if this helps! Feel free to reach out if any questions.
3 Replies
Hi pitscompany,
I think there is no native way to dynamically bind the Rows and Columns properties to a measure or field parameter. In native Power BI visuals, the Grid Layout dimensions for small multiples are hardcoded formatting properties that cannot accept conditional formatting (fx) inputs.
You can look into custom visuals like Deneb that allows you to build custom charts using Vega-Lite JSON specification.
- https://marketplace.microsoft.com/en-us/product/power-bi-visuals/coacervolimited1596856650797.deneb?tab=overview&hl=en-AU
- https://deneb.guide/?hl=en-AU
Let me know if this helps! Feel free to reach out if any questions.
Hi pitscompany
Thank you for reaching out to the Microsoft Fabric Forum Community.
Bipin-Lala Thanks for the inputs.
I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi pitscompany
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
