Hi, I have a bar chart with a single metric “gross profit”. Is it possible to recolour the bars so where the value is less than zero the bars are in red and when the values are above zero the bars appear in green? Thanks.
Hi,
While this solution might not fully address your request, it could be a helpful starting point as you await a more detailed response from the community. Let’s consider a scenario where you have a table displaying Gross Profit per Country in the EU.
The objective is to visually distinguish between positive and negative profits using colours, specifically, red for negative values and green for positive ones. Instead of using a Bar Chart, we’ll use a Table with Bars chart type. This approach allows us to maintain the visual representation of bars while also leveraging the conditional formatting options available in table charts.
To format the table background in Looker Studio, start by selecting the table chart you want to format. Next, navigate to the “Style” tab and scroll down to the “Conditional Formatting” section. Click on “Add Rule,” set the condition (such as Profit < 0), and choose your desired background colours, red for negative values and green for positive ones. Finally, apply the changes to see the conditional formatting in effect.
This setup will automatically colour the table background based on your specified conditions, making it easier to visually interpret the data.
Hi @Sichali1 .
Thanks for providing this option.
I was hoping to be able to colour just the bars so will see if anyone else has any ideas.
But thanks again.