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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors