cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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!

13 REPLIES 13
Highlighted
Microsoft
Microsoft

Hi @Anonymous

 

It doesn't look like sorry.  Sounds like a great idea though


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Microsoft
Microsoft

Hi @Anonymous,

Up to date, there is no way to change the background or font color of a table cell for a text. Please review the following feature requests and commont on them.

 

Conditional Formatting for Text
Better Conditional Formatting Tools

Best Regards,
Angelia

Highlighted
Advocate I
Advocate I

This idea is currently "Started":

Conditional formatting (cell highligh, font, etc) when comparing multiple fields

 

I've been needing this functionality for months now.

 

Thanks

Kevin

Highlighted
Anonymous
Not applicable

Thanks for the update @kevcurtis

Highlighted
New Member

The  May Update includes the ability to condtionally format text fields, as long as you choose a numeric value to format on.

Highlighted
New Member

The May Update added this functionality. Now, users can conditionally format text and date fields, as long as you choose a numeric value to format on.

Highlighted
Regular Visitor

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.


Highlighted

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

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors