I am facing a issue on my current project.
If any of the bar chart data is less than 1 and greater than 3, then it should be represent in the RED color. The other color representation will be in Blue color. I am attaching actual and required sheet.
Kindly help me.
Assuming the bars result from sum([your measure]) you need a calculated field on the color shelf something like:
if sum([your measure]) >3 or sum([your measure]) <1 then "Outside" else "Inside" end
then set the colors as needed