Conditional formating waterfall(or bar chart) not working as intended

Question

Hello all, I am trying to conditionally format the data labels colors based on a measure.

Here is my conditional measure :

Indicador Payback =

VAR checkant = CALCULATE('Metricas Consolidado'[Check Payback],DATEADD('Calendário'[Data],-1,MONTH))

VAR checkatual = 'Metricas Consolidado'[Check Payback]

IF(

checkant = FALSE() && checkatual = TRUE(), TRUE(), FALSE())

RETURN

IF(indicador =TRUE(),"red","blue")

Using it in a waterfall graph (does not work on a column chart either) the month oh 06/2022 should be colored red however it comes out as blue

I know the measure is working because I have tested it on a table and it works (returns red or blue accordindly and the red output is only on june) also using it as a tooltip over the graph above it is displayed correctly as well (the other months show up as blue)

It is configured corretly

Also if I try a simpler conditional formatting it is not working as well (should have turned everything below 0 into a red font) but does nothing.

Here goes the file iself It uses mocked data so there is no sensitive data inside.

https://drive.google.com/file/d/1yny_A6lk8H2denKPHl2ZW-Zw1ATLiF6V/view?usp=sharing

Help appreciated.

v-chenwuz-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
The current position, waterfall map can only support font color uniform modification, can not be defined individually.
&nbsp;
You can submit your idea to power bi ideas websit.
&nbsp;
Best Regards
Community Support Team _ chenwu zhu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Conditional formating waterfall(or bar chart) not working as intended

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting