How to change text colour in rows in a dimension

[Anonymous]

How do I change the text colour to red in two of the rows in the following table -

I would like to always highlight the 'Distance Learning', and 'Other open...' rows in red text.

Thanks

Greg

[sunny_talwar]

Use background color for your dimension. Did that not work?

[Anonymous]

I assume I would use the background colour on the dimension, but how do I change the text colour for just two of the rows in the dimension?

Thanks

[sunny_talwar · Accepted solution]

Using an if statement...

If(WildMatch(DimensionName, 'Distance Learning', 'Other open learning*'), LightRed())

[jonathandienst]

Use an expression like:

If(Match([Mode of attendance], 'Distance Learning', 'Other....'), Red())

Just adjust the field and conditions in the match to your requirements.

[Anonymous]

Thanks very much

[Anonymous]

Why isn't the 'Other open learning...' field showing as red text in the following table?

I think it is because the first data column in the table has no value for the 'Other open learning...' row, eben though there are values in data columns 2 and 3.

How do I fix it to always show red?

Thanks

[sunny_talwar]

Try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps

[sunny_talwar]

Also did you Match or WildMatch? Can you share the expression you used?

[Anonymous]

Thanks , that worked but it replaced the '-' with'0'