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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors