Conditional Formatting rules on cell value

[JemmaD]

Hi there,

I have a table with [Country], [Score] and [Difference].

The [Difference] column contains only -1, 0 and 1. If the Score is higher than the previous year it holds a 1, if it's the same then 0 and if it's lower than the previous year it holds -1. This field is a text column so I could use it to create conditional formatting icons for up, down and side arrows.

If it's a number column I cannot use this field as it simply counts and I cannot use the Field value, only Rules. 

The icons work but only if the [Difference] column is exposed in the table, but I don't want it in there - I just want to hold the icon against the [Score] column to show where it sits compared to the previous year. 

How do I get icons to work against this field without exposing the field in the visualisation?!?

[Akash_Varuna · Accepted solution]

Hi @JemmaD , You could use conditional formating please try these 

• Apply Conditional Formatting:

  • Select [Score] in the table visual.
  • Go to Conditional Formatting > Icons and set rules:
    • 1→ Up Arrow (green).
    • 0→ Neutral Arrow (yellow).
    • -1→ Down Arrow (red).

• Remove [Difference] from the Visual:

  Conditional formatting will still work even if [Difference] is not visible.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[JemmaD]

Hi @Akash_Varuna 

I'm afraid that is what I am reporting as not being able to do. 

This is what I have in conditional formatting:

It won't let me change 'First Difference' to anything else.

This is the result when Difference is in the table:

This is the result when I take it out: