Conditional Formatting on column chart

[Ranjeet_1989]

Hi,

I'm creating column chart in power bi and want apply conditional formating on both bars profits and Sales.

Like if Profit>=3000 then Green, Profit>=1000 then Amber, Profit <1000= Red

Like if Sales>=4000 then Green, Sales>=3000 then Amber, Sales<1500= Red.

There is no option on column formating tab.

Please help me on this.

[Ritaf1983 · Accepted solution]

Hi @Ranjeet_1989 

Conditional formatting is not supported by multiple columns in the category.

It is also not effective in terms of data visualization.
Beyond that, it is difficult to compare anything beyond each pair individually,
We burden the user with another type of decoding by using conditional formatting that allows both sales and profit to appear in the same color.

Alternatively, you can use the table graph in the picture, which allows you to compare cities, compare sales and profits, and alert you to the circle's values that you need.

There are quite a few steps in creating, so I am attaching a link where you can download the file and follow my steps.
Link to a sample file 

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

[Ritaf1983 · Accepted solution]

Hi @Ranjeet_1989 

Conditional formatting is not supported by multiple columns in the category.

It is also not effective in terms of data visualization.
Beyond that, it is difficult to compare anything beyond each pair individually,
We burden the user with another type of decoding by using conditional formatting that allows both sales and profit to appear in the same color.

Alternatively, you can use the table graph in the picture, which allows you to compare cities, compare sales and profits, and alert you to the circle's values that you need.

There are quite a few steps in creating, so I am attaching a link where you can download the file and follow my steps.
Link to a sample file 

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

[Anonymous]

Hi @Ranjeet_1989,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ranjeet_1989]

City	Sales	Profit	Month
Delhi	7000	1500	January
Mumbai	5600	1400	February
Kolkata	6500	900	March
Chennai	2800	600	April
Bangalore	4500	1800	May
Pune	3000	800	June
Delhi	1500	400	July
Mumbai	1400	700	August
Kolkata	900	300	September
Chennai	600	350	October
Bangalore	1800	450	November
Pune	800	100	December
Delhi	2000	650	January

[Anonymous · Accepted solution]

HI @Ranjeet_1989,

I test with your sample data but can't apply conditional color formatting on column chart with multiple value fields.
Perhaps you can take a look at Ritaf1983 's suggestion or try to manually plot the graph based on condition on script base visuals. (e.g. R, Python visuals)

Create Power BI visuals using R - Power BI | Microsoft Learn

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn

Plot with conditional colors based on values in R - Stack Overflow
Regards,

Xiaoxin Sheng