LinkedIn
Twitter
The “transparent” color in Looker can be used to hide many different elements of a visualization. One useful way to use this color is to selectively hide value labels.
Currently, in Looker, the value label setting operates on all value labels; it’s not possible to apply labels to specific series. Fortunately, it’s very easy to work around this by using the transparent color in the ‘Series Colors’ option.
(Sneak Peek! We will soon be introducing additional visualization settings that will make this method unnecessary. Keep an eye on those release notes!)
Here’s the result set I’m going to work with:
In the image below, I’ve toggled on ‘Value Labels’ and ‘Totals Labels’. I’d like to hide the value label for the green ‘Yes’ series but keep the others.
The input to ‘Value Colors’ corresponds to the series in the order that they are listed in the legend. By using white, transparent in the ‘Value Colors’ setting, I’ve hidden the ‘Yes’ series.
