Forum Discussion
Conditional Format Font Colour and Change Format of Value
Hi all,
I have a measure for finding Variance, however, I need the negative to look like this (312) with red as the font.
Hello Anonymous ,
Please check FORMAT Function. It returns Text. So your number becomes a text and text measures cannot be conditionally formatted.
You should create a numeric variance measure:
Variance =[RF Day] - [Budget Day] It is numeric.
After that, select the variance measure from the data pane and a new pane will open up at the top. You will see format. Enter that #,0;(#,0);0 in there.
Now you can apply conditional font color, if value <0 Red etc.
If this solved your issue, please mark it as the accepted solution. ✅
4 Replies
- anilelmastasi
Super User
Hello Anonymous ,
Please check FORMAT Function. It returns Text. So your number becomes a text and text measures cannot be conditionally formatted.
You should create a numeric variance measure:
Variance =[RF Day] - [Budget Day] It is numeric.
After that, select the variance measure from the data pane and a new pane will open up at the top. You will see format. Enter that #,0;(#,0);0 in there.
Now you can apply conditional font color, if value <0 Red etc.
If this solved your issue, please mark it as the accepted solution. ✅
- anilelmastasi
Sometimes brain freezes 😄 you are welcome
- anilelmastasi