Forum Discussion

Pricey79's avatar
Pricey79
Helper V
3 years ago

Conditional Formatting only working on half a visual

Hello, I was hoping someone could help me please.

 

I have a date column , that is made from this : 

DATES = IF(ISBLANK(Table1[Due Date(Task)]) , Table1[Due Date(Task2)], Table1[Due Date(Task)])
That works fine and gives me the dates I want. However, conditonal formatting is doing something very strange. 
 
Their are 2 sets of records in Table1 that have been appended together. Record1 and Record2. The formatting is working fine for Record 2, but for Record 1 its showing different colours. 
 
These are the incorrect ones(Record1)
And this is the format:
 
Due_Status_action = IF('Table1'[DATES]<TODAY() , "Overdue" ,
IF(('Table1'[DATES] -7)<TODAY() , "Due In One Week Or Less" ,
If(('Table1'[DATES]-14)<TODAY() , "Due in 1-2 Weeks" ,
"Due")))
 
And this is the colours:
Status_Colours = IF('Table1'[Due_Status_action] = "Overdue" , 1,
IF('Table1'[Due_Status_action] = "Due In One Week Or Less" , 2,
If('Table1'[Due_Status_action] = "Due in 1-2 Weeks" , 3,
0)))

 And then this is the colour:

Green seems to work but nothing else?

 

Any help would be much appreciated

 

Thank you

Need Help

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    3 years ago

    Hi Pricey79 

    Can you please check the date column type before combined
    Should be Date format only in both the table (not date time)

    If solved, mark as solution

    • Pricey79's avatar
      Pricey79
      Helper V
      3 years ago

      PijushRoy  Thank you for taking the time to reply

      I've changed the date format and now I get this?

       

       

      • PijushRoy's avatar
        PijushRoy
        Community Champion
        3 years ago

        Pricey79 

        Can you please rebuild the table from scratch and measure. I hope error for, same column as per datatype is already used in DAX, better to copy the dax and power query step and rebuild the table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Pricey79,

    Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng