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