help regarding specific desired conditional formatting

[GX_1]

Hi Everyone!!

I have set up conditional formatting to a value which a target. so I wanted the pictured below conditional formatting with the corresponding colours below but an error keeps popping up so I can't save my preferences. any work around or help understanding why would be amazing!!

goal of what I would like: 

desired PBI conditional formatting

with the greatest thanks!!

[aj1973 · Accepted solution]

Hi @GX_1 

I join @jdbuchanan71  to his question but if the format is % then you need to settel it like this

[aj1973 · Accepted solution]

Hi @GX_1 

I join @jdbuchanan71  to his question but if the format is % then you need to settel it like this

[jdbuchanan71]

Even if it is a % field you will still want to use the Number selection. I have had problems with PowerBI and the percent selection in conditional formatting.

[jdbuchanan71]

Your 3rd line doesn't make sense.  No number is > 5000000 AND <= 0.  Also, why are you mixing Percent and Number in your selection.  What is the data type of the field you are trying to format?  Is it a % like attainment or $ like Budget? 

[GX_1]

so from the 'based on field' column there are a bunch of values and I just want to understand when the values go above 5% or drop below 5% similarly when the values are less than 0 or >5k on a monthly or yearly basis etc

is there anyway to take away 'AND' in the conditional formatting pictured? it just automatically pops up 

[jdbuchanan71]

Please show us the report visual you are trying to format and hightlight the columns you are wanting to format.  A single field that has both 5% or $5000 doesn't make sense to me.

[GX_1]

I think i understand the confusion! 

So this column that I am conditionally formatting is based on another column called 'customer forecast' that has a bunch of values. 

i assumed that the column since its based on another column (customer forecast) which is a target - that I could just apply the rule to see if its variating above 5% or below 5% of the target... but I think that isn't the case. conditional formatting just buckets values and colours them accordingly right? 

[jdbuchanan71 · Accepted solution]

For basic conditional formatting you are correct.  You can format a column based on another measure so you could format your sales $ based on margin %.  Here for example I have formatted the text color of [Quarter in Calendar] based on the value of the measure [Days in Quarter]