Forum Discussion
brittanyruffin
1 year agoHelper I
conditional format clustered column chart power bi
I want Q1'25 to be orange. i have 2 measures, one for the light blue and one for the dark blue. cant figure out a way to change just the Q1 bar to be orange and the others to be dark blue. ...
parry2k
1 year agoSuper User
brittanyruffin with two measures you cannot apply conditional formatting, it is one color for each measure or nothing.
To get creative, create 3rd measure, that will only return the values for q2 to q4, and the original measure you want to be orange should only return the value for q1. This way you will able to change the color of a single bar.
brittanyruffin
1 year agoHelper I
i tried that as well but then there are large spaces in the quarters where the orange bar is blank. i tried multiple dax calcs to eliminate the bar but nothing would work.