Forum Discussion
Center aligning column data by default in Table and Matrix visuals - JSON theme or other methods
- 6 months ago
Hi JeffSwanson ,
Thanks for reaching out to the Microsoft fabric community forum.
I have reviewed the original requirement and would like to clarify the current product behavior to avoid any confusion. Your goal is to have all values in Table and Matrix visuals center aligned by default, ideally managed through a JSON theme so manual adjustments are unnecessary.Currently, Power BI and Fabric do not support this functionality within the theme schema. Although there is a horizontalTextAlignment property in some visual style settings, it does not set a global default for all data cells in Table or Matrix visuals, nor does it override the default behavior of left-aligning text and right-aligning numeric values.
As a result, there is no theme-based solution to automatically center align all columns in these visuals. The most reliable approach remains adjusting alignment per column in the Format pane or using a pre-formatted report template for future reports. This is a product limitation at present, rather than a configuration issue.
Thank you.
Looks like they have changed. You may need to add "horizontalTextAlignment"
Offical ref:
https://github.com/microsoft/powerbi-desktop-samples/blob/main/Report%20Theme%20JSON%20Schema/reportThemeSchema-2.150.json