Text on Axis Coluring for certain conditions

[spikenaylor1]

I have expression showing as text on axis

I need to colour this text based from a list of Batch numbers to indicate new data for chart

I NoConcatenate Load a list of Batches that need to be highlighted as new batches for the monthly report

on the Text Colour part of the expression

my formula is

= If(substringCount(GetFieldSelections(Batches_to_Include),Batch)>0,Brown(),LightGray())

Selecting any Batch from the Batches-to-Include list colours the text brown

selecting any combination colours text brown

selecting all of the list fails, no brown colouring

cant work out why this is

any advice greatly received

Many thanks for looking

[tresesco]

Could you share a sample app and explain the expected output in that context?

[spikenaylor1]

quicker to use photos

Please see photos below for what happens

No Selections made

No Selections Made

Some Selections made

Some Selections made

All but one selected

All but one selected

All selected

All Selected

[tresesco · Accepted solution]

What if you try like:

= If(substringCount(GetFieldSelections(Batches_to_Include, '|', 100),Batch)>0,Brown(),LightGray())

[spikenaylor1]

Many Thanks

that sorted it

Regards