cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Re: Conditional formatting for a text column

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

Re: Conditional formatting for a text column

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

Re: Conditional formatting for a text column

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

Re: Conditional formatting for a text column

Thanks for the update @kevcurtis

Highlighted
New Member

Re: Conditional formatting for a text column

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

Re: Conditional formatting for a text column

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

Re: 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.


Highlighted
Helper II
Helper II

Re: Conditional formatting for a text column

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
Advocate I
Advocate I

Re: Conditional formatting for a text column

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors