Conditional Formatting

Hey Guys,

I just had a simple question I am trying to apply conditional formatting on a field called Variance %.

and I realize it doesn’t show, I am thinking it’s based on the code I use with the FORMAT function, it seems it doesn’t allow it to apply the conditional formatting when I choose the data bar option. Note if I remove the FORMAT function which would give 0.18 instead of 18% it would work though.

I am wondering if there is a workaround for this.

1

Do you mean you cannot apply conditional formatting when the DAX measure include FORMAT?

Could you share PBIX file?

@ctvv3010 that’s correct, FORMAT returns a text string and not a number that’s why conditional formatting for Data bars won’t work.

Don’t know if there’s a workaround for this one…

Custom numeric formats for the Format function.

https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function

Hi @Stefan, A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!