Using last value of column for conditional formatting

Question

Hi!trying to use the last value for the conditional formatting of the background of a chart.The last value display correctly in the tooltips but not when put onto a card. and also not when used as the condition for the background color, as the last value would be grey, instead it is white.&nbsp;What am I missing?As always, thanks in advance!&nbsp;

nandukrishnavs · Answer

MelStaunton&nbsp;Try something like this.Measure = CALCULATE(SELECTEDVALUE(MyTable[MEDesignOverdueFlag#]),FILTER(MyTable,MyTable[RecordCREATEDDATETIME]=MAX(MyTable[RecordCREATEDDATETIME])))&nbsp;Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂

melstaunton · Answer

Thank you, that works.&nbsp;

Forum Discussion

Using last value of column for conditional formatting

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Conditional Formatting

Condition formatting