Forum Discussion
Dynamic small multiples grid layout auto‑adjust rows/columns based on 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.
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.