Reverting a column background back to transparent

[joyhackett]

Does anyone have a trick to change the background color back to "no color"? The only way I have found to choose "no color" is to reset ALL columns back to the defaults (but that really stinks if I have already formatted many columns.)

[Anonymous · Accepted solution]

Hi @joyhackett ,

You can create the measure, write a transparent color using the measure, and then use conditional formatting to change the background color of the field to the measure.

mask_transparency = IF(MAX('financials'[COGS]),"#000000000")

The final result is shown below:

You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.