Forum Discussion

Frequent Visitor

16 days ago

Solved

Why can I not conditional format my visual

Hi,

I am struggling to format my table - just a excel file

All I want to do is change the negative values to red in the 'FC Q2 Income Variance'.

But the conditional format is NOT allowing me too (see the below)

Any idea why?

MFelix
15 days ago
Hi Adavin ,

Is the FC Q2 Income Variance a measure or a visual calculations? Make sure that is in the number format if it's a measure just check the format, if it's a visual calculation you need to use the Data format pane in the visualization:

3 Replies

MFelix
Super User
15 days ago
Hi Adavin ,

Is the FC Q2 Income Variance a measure or a visual calculations? Make sure that is in the number format if it's a measure just check the format, if it's a visual calculation you need to use the Data format pane in the visualization:
Adavin
Frequent Visitor
15 days ago
Hello Thanks for coming back much appreciated.
I have fixed this by just adding in
DAXFontColor =
IF(
SUM('Income 25-26 Forecast by Quarter'[FC Income Q2]) < 0,
"Red", -- Red for negative
"Green" -- Green for positive or zero
)
- MFelix
  Super User
  15 days ago
  Hi Adavin ,
  
  Glad you were able to solve it, don't forget to accept the right answer so it can help others.