Forum Discussion

Jwood993's avatar
Jwood993
Frequent Visitor
4 years ago

Help to conditional format text in a specific Column

Hi I want to achieve something on my report where the data will conditional format for any text value that is repeated more than once. I want this to highlight to the viewer that the text is appearin...
Need Help
SolomonovAnton's avatar
SolomonovAnton
Super User
4 years ago

hello ! 

 

you should create measure 

color = 
var _RowsCnt = COUNTROWS('Table')
var _Result = IF(_RowsCnt>1,"Green",BLANK())
return _Result

 

after do apply it measure to conditional formating background 

do the same settings 

 

you will get follow result 

 

if I answered at your question please make topic as resplved 🙂

 

 

Jwood993's avatar
Jwood993
Frequent Visitor
4 years ago

Hi It's not working and it doesn't let me select the specific column heading that i want to assign the formatting to. It only comes up with the original table name.

 

Thanks

  • SolomonovAnton's avatar
    SolomonovAnton
    Super User
    4 years ago

    please describe with more details then I could be help you 

    • Jwood993's avatar
      Jwood993
      Frequent Visitor
      4 years ago

      Basically what I'd like to achieve is that in my table there is separate columns that show the name and store someone works at. It also shows different projects that are launching and I'd like to highlight store names where multiple projects might be going live that week (I've got all the filters setup already)

       

      So if in store 5555 there is 3 events happening it highlights to alert the viewer that there's large amounts of activity occuring at once.

       

      I've attached another image to try and show what I need

       

      Thanks