How to color bars in a bar chart using conditional formatting in Looker Studio?
Until very recently, this could be done using a dirty trick involving breakdown dimension and cumulative, but it was very limited. Now, you can do it better and natively!
Remember the good old times when you wanted to have bars colored differently in a bar chart? Set your dimension, use the same dimension or a dirty formula as a breakdown dimension, set to cumulative, and see it somewhat working? This time is over thanks to a new feature recently released! Today, we’ll review how to color bars in a bar chart using conditional formatting in Looker Studio.
Looker Studio connectors we use on a daily basis and are happy with (w/ free trials): Supermetrics - Windsor - Catchr - PMA - Funnel (some affiliate links, still good tools!)
Not sure which one to pick? Reviews here and there. Still unsure?! Contact us with your tech stack and budget, and we’ll guide you in the right direction:
So, this one is pretty straight-forward, you’ve got your report and your data source. Just add a bar chart, set your dimensions, metrics, filters, … and then proceed to the Style ribbon. You should see something new:
Now, you know the drill, click on Add formatting, play with your rules, and make some magic. It works just like Conditional formatting for tables, but in this case, the color is applied to the bar, to the data label, or to both.
Again, you can add several conditionnal formatting (beware of the order in which they get applied), so very similar to what we add for tables, applied to charts. In other words, possibilities are endless!
Can it be applied to combo chart? Well… Not yet! Let’s hope they take care of that soon.
And that’s it for today. Not sure a full article was the best way to present this, but we currently don’t have any other section on this site to do so ^^
In this article, we’ve presented you a new feature recently released by Google: how to color bars in a bar chart using conditional formatting in Looker Studio.
PROBLEM SOLVED
The infamous affiliate links section. Still, these are tools we do use and do like a lot. To be said, we use other tools we’d rather not publicize given the headache they cause!
Todoist: for tasks management
Clickup: for projects management, when tasks fall short
Monday: for CRM & automation
Tropical Server: our friends in charge of the hosting of this very website!
Tools we use through clients’ accounts (and we’d use internally if we had the budget…):