Forum Discussion
Conditional formatting for a text column
I had the same problem and this is what I did:
- Create a new column
- Create an IF formula based on your text column, make it take numbers instead of the values. For example, my text column contained "Yes" and "No". I used the formula New column = IF([Textcolumn]="Yes",1,0).
- Go to the Conditional formatting option and chose to conditional format based on another column, chose your newly created column.
- You can do this with the first two types of conditional formatting: by color scale and by rules.
why is it if i choose conditional formating based on another column it automaticly uses SUM but i do not want it to sum just take the value
As an alternative you can use a measure to retrieve the first value for conditional formatting instead of column aggregation.
First Value = FIRSTNONBLANK('Table'[Column 1],'Table'[Column 1])
Or try changing the default summarizition for the column in the modeling tab. Click the column, Modeling > Default Summarization
