Conditional Formatting of Clustered Column Chart

[Anonymous]

Hi, I want to create a chart like this. (picture below is a chart from SAS Viya)

so i'm using a clustered column chart in power bi as below.

I only use 'Values' section.

Now I want to change the chart colour. Why doesn't this have conditional formatting?

[Anonymous]

Hello @Anonymous 
I think it's not possible until adding the axis.

[Anonymous]

@Anonymous 

@amitchandak I was thinking to do an if statement. this are the example 

Column = IF('Table'[value]<=10,"green", 
IF('Table'[value]>=11 && 'Table'[value]<=30,"yellow",
"red"))

but how can I add my preferred colour code?

[Anonymous · Accepted solution]

Hello @Anonymous 
You can simply put the column and manage the conditional formatting by setting up the data color.
Apply the rules or measures to do the conditional formatting.

[amitchandak]

@Anonymous , Are you using line too?

If you have two measures line and bar. It will not show

[Anonymous]

@amitchandak That one is a constant line. because I want to show the target line. I tried to remove the constant line, but it is still the same

[amitchandak]

@Anonymous , if no axis, no option for conditional formatting, I checked with a measure and average line (Using analytics). Looking at bar one doubt that.

You add one constant column and add that axis and check