Forum Discussion
Solved
Dax Color Conditioning not working for all Rows
Hi guys, so I have this conditioning in DAX: Task = SWITCH (TRUE (), 'Table'[Date] < TODAY (), "#FD625E", WEEKNUM ( ''Table'[Date], 2 ) = WEEKNUM ( TODAY (), 2 ), "#FFD86C", WEEKN...
We realized that when the 'Table'[Date] column defaults to 1/1/1900 due to an error in the date, it breaks the color conditioning (or the color condition don't work properly). The Problem resolved itself the moment that was fixed from the source file. Thanks!
We realized that when the 'Table'[Date] column defaults to 1/1/1900 due to an error in the date, it breaks the color conditioning (or the color condition don't work properly). The Problem resolved itself the moment that was fixed from the source file. Thanks!