topic Re: color Dynamic Format in DAX Commands and Tips

color Dynamic Format

Luquiluk — Fri, 05 Jul 2024 13:38:24 GMT

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)

Re: color Dynamic Format

mark_endicott — Fri, 05 Jul 2024 13:58:09 GMT

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.

Re: color Dynamic Format

Luquiluk — Fri, 05 Jul 2024 14:13:19 GMT

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)

Re: color Dynamic Format

mark_endicott — Fri, 05 Jul 2024 14:16:26 GMT

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

Re: color Dynamic Format

Luquiluk — Fri, 05 Jul 2024 15:29:56 GMT

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