Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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

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

TallesLessa_0-1656427173602.png

 

 

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)

TallesLessa_1-1656427279258.png

 

It is configured corretly 

TallesLessa_2-1656427363745.png

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.

TallesLessa_3-1656427522950.png
 
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.

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous ,

 

The current position, waterfall map can only support font color uniform modification, can not be defined individually.

 

You can submit your idea to power bi ideas websit.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous ,

 

The current position, waterfall map can only support font color uniform modification, can not be defined individually.

 

You can submit your idea to power bi ideas websit.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Oh, Gonna suggest that then, Thank you.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors