Forum Discussion

bestevez's avatar
bestevez
Helper I
6 years ago
Solved

Pivot Table

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...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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.