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

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

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

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors