Forum Discussion
Conditional formatting for a text column
Hi PBI community, Is there a way to change the background or font color of a table cell for a text based column using DAX. Any help would be appreciated. Thank you!
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