Forum Discussion
color Dynamic Format
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)
4 Replies
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-numbers-in-the-column
If this works, please accept as the solution.
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)
Luquiluk - Yep, not going to happen. Suggest you find a different way to visualise this.
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
