color Dynamic Format

[Luquiluk]

I have the following DAX composition in dynamic format, but I can't get the negatives to be red

VAR AA = [AA]

var BB = [BB]

var _Formato_AA = FORMAT(AA,"#0, K")

var _Formato_BB = FORMAT(BB,"#0, K;[Rojo] -#0, K","es-ES")

VAR _def = UNICHAR(34) & _Formato_AA & UNICHAR(34)&"  ("&_Formato_BB&")"

return _def & UNICHAR(34)

[Luquiluk]

I try to make a waterfall graph that shows me the two data and that the bars have the size of the data of A and has a sequence of the data of B and the color of the column conditional on B

[mark_endicott]

@Luquiluk - you can't set the colour of a result inside FORMAT() you need to use conditional formatting on the measure / column.

This article has some good pointers on it: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

If this works, please accept as the solution. 

[Luquiluk]

The problem is that it is text of two measures AA and BB, I want that when BB is negative only the BB in red comes out

1100K (18K)

2200K (-25K)

[mark_endicott]

@Luquiluk - Yep, not going to happen. Suggest you find a different way to visualise this.