Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
Anonymous
Not applicable

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

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.