Custom Pivot Table - Put color into first column and other color into second

[SaCvP125]

Hi guys,

I've a Pivot table which gives me the number of goals of each team for each part of the game. So simple as this:

	After First-Half	Before First-Half
Team A
Team B
Team C

And I want to add a conditional formatting that allows me to:

• If exists any goal after the First Half the column should be red otherwise should be blank;
• If exists any goals before fi the the column should be grey otherwise should be blank.

The following image illustrate the pivot table that I want:

	After First-Half	Before First-Half
Team A	1	0
Team B	0	1
Team C	0	4

-

There exists any custom visual to do this?

Many thanks for your help 🙂

[v-yuezhe-msft · Accepted solution]

@SaCvP125,

You are able to get the above visual by creating a table visual and configuring conditional formatting. Please review the following screenshots to get more details.







Regards,
Lydia