Conditional Formatting rules on cell value

Question

Hi there,I have a table with [Country], [Score] and [Difference].The&nbsp;[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.&nbsp;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.&nbsp;How do I get icons to work against this field without exposing the field in the visualisation?!?

akash_varuna · Accepted Answer

Hi&nbsp;JemmaD&nbsp;, You could use conditional formating please try these&nbsp;Apply Conditional Formatting:Select [Score] in the table visual.Go to Conditional Formatting &gt; 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]&nbsp;is not visible.If this post helped please do give a kudos and accept this as a solutionThanks In Advance&nbsp;&nbsp;

Forum Discussion

Conditional Formatting rules on cell value

2 Replies

Related content

Conditional formatting based on rules

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting