Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Color Coding with IF in Power BI

I am trying to color code a column in my table with an if statement.   I keep getting an error message.  Any help would be greatly appreciated.  Here is my Dax formula.   =IF(AND([Calibration Due]]>...
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I think you missed two things. color measure text measure should be separate

example measures

=IF(AND([Calibration Due]]>reportdate,[Calibration Due]]<TODAY()+90),"Due Within 90 Days",IF([Calibration Due]]>TODAY,"In Calibration",
"CALIBRATION"))

 

color =

IF([Calibration Due]]>TODAY() <> 90, "Green", IF([Calibration Due]]>TODAY,"Yellow", "white"))

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I am new to Power Query.  I tried to add this column  I am getting error message "Token Literal expected".  Here is my DAX in power query 

= Table.AddColumn(#"Changed Type1", "CalDueFormat", each if [Calibration Due] > Date.From(DateTime.LocalNow()) & if [Calibration Due] < Date.From(DateTime.LocalNow()+ 90 then "Due in 90 Days" else if [Calibration Due] > Date.From(DateTime.LocalNow()) then |
"In Calibration" else "OverDue")

 

The color measure you suggested work but wrong colors appear due to my column I added.  It will not mark the overdue rows.