cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pricey79
Helper V
Helper V

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)))

Pricey79_0-1667929669030.png

 And then this is the colour:

Pricey79_1-1667929974526.png

Green seems to work but nothing else?

 

Any help would be much appreciated

 

Thank you

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
PijushRoy
Super User
Super User

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

@PijushRoy  Thank you for taking the time to reply

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

 

Pricey79_0-1667937337170.png

 

@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.

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors