cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Conditional formatting for a text column

I have found a solution which may help which I got help from one of my team members:

 

  1. Create a number value for the word by creating an additional column. For example 'Yes' as '1' and 'No' as '2'.
  2. Make sure the additonal column value is a whole number and not text.
  3. Apply and close
  4. Go to the field, use the drop down in the fields section and choose 'conditional formatting' - choose Background or Font colour.
  5. Choose 'Rules' for 'Format by'
  6. 'Summarization' as 'Minimum'
  7. Choose the number and the colour If value is '1' then 'Green'
  8. Click OK and it should work 🙂
Anonymous
Not applicable

Re: Conditional formatting for a text column

Perfect, thanks!

Highlighted
Anonymous
Not applicable

Re: Conditional formatting for a text column

Exactly what I was looking for, thanks.  Mind you, being able to apply a format directly to a field based on a text value doesn't seem like it would be that difficult.  It's certainly been something that I could do in Excel for years - come on Microsoft.

Highlighted
Frequent Visitor

Re: Conditional formatting for a text column

This post provides one method: https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/

 

The DAX is essentially:

Colour Test =
VAR Dept = SELECTEDVALUE(Projects[Department])
RETURN IF(Dept <> BLANK(), "Green", "Red")
 
 

Helpful resources

Announcements
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!.

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