Forum Discussion
Color coding based on changing baseline and target
Hello, I'm trying to create a line and cluster column chart that changes colour when the baseline and the target are met. One colour below the baseline, one colour above the baseline and one col...
Hi sdegroot,
You can try to create a calculated column to return result whether the actual value meet the baseline or target. Then use this new column in the Column Series property.
ColorCondition = SWITCH(TRUE(),'Table2'[Actual]<'Table2'[Baseline],"Red",'Table2'[Actual]>='Table2'[Baseline] && 'Table2'[Actual]<'Table2'[Target],"Yellow",'Table2'[Actual]>='Table2'[Target],"Green")
Best Regards,
QQiuyunYu
Thank you, that was very useful!
It looks like I cannot use this same method when creating a table. The table should follow the same code as below but, from my understanding of previous posts, conditional formating is not available from a value in a table unless it is an aggregated value. Is this true?
