Dax Warning measure

[Anonymous]

Hi all,

I have a dax query which looks like this 

Expiry warning = var __diff = DATEDIFF(MAX(Pipeline[Delivery Date] ) , MAX(Pipeline[Approval Expiry Date]),MONTH ) return IF( HASONEVALUE(Pipeline[Delivery Date] ), IF( __diff <= 3 , " 🔴 " & __diff & " months" ,"🟢 " & __diff & " months" ) )

however id like to create something like this for a completely different factor.

I have 3 types of spreads -
original - current - difference 

i would like the dax query to highlight in a separate column in the table when spread current falls under 2.00

Would this be possible?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, you want a separate column to highlight when the Current column falls under 2, here's my solution.

1.Create a blank column.

Column = BLANK()

2.In the Visuallizations pane, select the new column, turn on the Background color.

Set it like this:

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@amitchandak 

Hi I was wondering if this was something you could help me with please?

[Anonymous]

forgot to add would this require conditional formattign or a dax measure

[amitchandak]

@Anonymous , I doubt I completely got it. But seem like it require two measures one return color and another unichar

example

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

I need little bit more details to help