Currently, Power BI does not allow local calculated columns (created in the report layer) to be used as category axes in Small Multiples visuals.
This limitation causes an error even when the same logic works perfectly in other visuals or when the column is part of the original dataset. The behavior is undocumented and leads to confusion for users working with composite models or temporary logic in local models. It would be highly beneficial if Power BI could support local calculated columns in Small Multiples, or at least document this limitation clearly.
This enhancement would improve flexibility in report development and reduce the need for workarounds like disconnected tables or Power Query transformations.
Suggested Improvement:
- Allow Small Multiples visuals to recognize and use local calculated columns as valid category axis fields.
- Alternatively, clearly document this limitation in the official Power BI documentation so users can plan accordingly.
Thank you for considering this enhancement to improve the Power BI user experience.
on:
UI for Editing Small Lakehouse Tables (Metadata & ...
on:
Power Automate visual in Power BI Desktop does not...
frithjof_v
on:
Job scheduler API: List failed runs