Pivot Table

[bestevez]

Hi,

I have some doubts about the pivot table. Why is it not possible to change the background color of the header when the values are put in rows? I get the color applied to the value field, even though in the field format I have chosen to apply to header as well.

Thanks for all.

[v-juanli-msft]

Hi @bestevez 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @bestevez 

As tested, if you add columns to "row" field and add columns/measures to other fields like "Value" field, then backgroud of the header can be colored as desired.

If you add measures in the "Value" field, no columns in "row" field, then the headers can't be colored as expected.

there is no header in the pivot table(matrix) from the third picture below.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.