Forum Discussion

annlois's avatar
annlois
Frequent Visitor
4 years ago
Solved

Conditional formatting based on a measure not working

I have a table visual where i have color indicators for 2 different columns coming from different data sources. What they only have in common: DATE   For some reason, all values that they can...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    annlois 

    It looks like one of your columns is a date and the other is date/time?  You can't join them together because on one side it will be 25/1/2021 10:02:05:056  and on the other side it will be 25/1/2021 00:00:00:000 so there would be no match.  
    In the table with the date/time you can make a column that is just the date then join them both to a dedicated date table.  That would be the way to go.

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

annlois 

It looks like one of your columns is a date and the other is date/time?  You can't join them together because on one side it will be 25/1/2021 10:02:05:056  and on the other side it will be 25/1/2021 00:00:00:000 so there would be no match.  
In the table with the date/time you can make a column that is just the date then join them both to a dedicated date table.  That would be the way to go.