Forum Discussion
matrix visual value alignment
- 3 years ago
You can change the alignment of values in one column at a time in "Specific Column":
Regarding the headers color, in the same menu ("Specific Column") select "Apply to header" and deselect "Apply to values" and "Apply to subtotals" and then change the color:
As some commenters have asked, there is a workaround that allows you to change the color of the header while still providing formatting to the values.
In the 'Specific Column' dropdown, toggle on "Apply to header" and "Apply to values". Choose the "Background color" you would like for your header. Choose your alignment (note: using this method it is not possible to have separate alignments for the header and values).
Next, open the 'Cell elements' dropdown. Select the same series as above and toggle on "Background color". Select the fx box underneath "Background color".
In the pop-up window, select the "Format Style" as Rules, "Apply to" Values Only. The "What field should we base this on?" should be pre-populated based upon the series you selected. The rule should be "If value is >= 0% and <= 100% then [color]". Choose the color to match the background of your matrix.