Forum Discussion
Conditional Formatting Text Color in a Table
Hi
I have a column in a table visual which I want to color based upon the value. So the values are text and there are only three uniqe possiblities and i want to give each option a Green, Red or a Gray color.
I already checked the conditional formatting option but that is around a numeric value but not text.
Any clues as to how to do it efficiently?
Thanks
Anonymous
You need to write a measure to read the value of the cell then return the name of the color.
Formatting = VAR _Value = SELECTEDVALUE ( 'Table'[Value] ) RETURN SWITCH ( _Value, "West","Green", "Central","Gray", "East","Red" )You would change West, Central, East to match your values.
Then you apply conditional formatting to the column > font color based on the Field value of the [Formatting] measure.
I attached a sample file for you to take a look at.
2 Replies
- jdbuchanan71
Super User
Anonymous
You need to write a measure to read the value of the cell then return the name of the color.
Formatting = VAR _Value = SELECTEDVALUE ( 'Table'[Value] ) RETURN SWITCH ( _Value, "West","Green", "Central","Gray", "East","Red" )You would change West, Central, East to match your values.
Then you apply conditional formatting to the column > font color based on the Field value of the [Formatting] measure.
I attached a sample file for you to take a look at.
- nandic
Resident Rockstar
Hi,
My approach is this: go to dimension where you have a field based on which you would like to set background color.
Add new column which sets color based on specific criteria (or add that column in source).
Example:
Then select table and add conditional formatting to desired field:
Define logic:
And this is final result:Cheers,
Nemanja
