Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
i have a stacked bar chart, which gives sales by two dimensions(dimension 1 for x axis and dimension 2 is for Stack split) and one expression (sales). so when i give conditional coloring, its working fine but i have Dimension 1 as a filter in my sheet so if i select a field value in that dimension 1 (I had nullified that dimension selection in my expression), only that bar is getting condition coloring, renaming all are getting default colors. please find the images below.
if i don't select the field value in dimension 1
if i select the field value in dimension 1
You might be using an expression for color. You just need to ignore selection in all/specific fields in your color expression to make this work.... use {1} to ignore all selections or {<Field1, Field2,....>} to ignore selection in specific fields