Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a bar chart with two measures.
Now, I want to color one measure(bar) with one color(Ex.. Blue) and want to color another measure(bar) based on condition. I tried all the coloring options available but none worked.
As per the above image, I want to color the second bar based on the condition ( when the first bar < second bar, the color of the second bar should be orange). and the first bar color should not be changed.
Color by Expression:
if([Dimension1]='Threshold', blue(),
if( AGGR(Count( {< [Dimension1]= {'Overdue'} >} OverdueMeasure), Dimension2) > .2,
rgb(255, 153, 51), green()
)
)