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.
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!
