Forum Discussion
Conditional Formatting of Clustered Column Chart
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?
6 Replies
- amitchandak
Super User
Anonymous , Are you using line too?
If you have two measures line and bar. It will not show
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
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?
