Forum Discussion

nalinda116's avatar
nalinda116
Regular Visitor
6 years ago

Conditional column using text string

Hi,   I have a data base which include debt follow-up remarks (calls) written in unstructured manner. I need to create a new/ conditional column to classify them in to 03 categories as "effective",...
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

nalinda116 , Not sure I got it. create a color measure using min/max of first nonblank on category column like this

 

Color Date = if(FIRSTNONBLANK(Table[date],TODAY()) <today(),"lightgreen","red")
if(FIRSTNONBLANK(Table[Value],"true") "true","green","red")

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

 

Then in conditional formatting use field option and use this measure

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

 

  • nalinda116's avatar
    nalinda116
    Regular Visitor
    6 years ago

    Thanks for the reply!

     

    But in involves "text" reading. I updated the original post with an example.

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi nalinda116 

      You could use conditional column in Transform data.

      Best Regards
      Maggie
      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.