The total value of Background color in pivot Table

[louise119]

Hi I use pivot table.
I set the total value each pivot table.
I wanna set the background color of the total value, but I don't know how to set the color.

Does anyone know how to?

[RafaelBarrios · Accepted solution]

Hi @louise119 

Try this,

in the measure look for "background color expression" option use and try

if(IsNull( dimesion_name ),red())

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!