Forum Discussion

Cornwalls's avatar
Cornwalls
Icon for Helper I rankHelper I
6 years ago

How to - Conditional Formatting - Percentage

Hi Everyone,   First time posting so go easy on me.   I am looking for a way to achieve the below result that Columns A+B+C+D=E   But if Column E is greater than 80% of Column F, it will be for...
Conditional Formatting
how to
percentage
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

You can do conditional formatting based on the value of a field - and that can be a field that isn't even on the visual. 

 

bgcolor = if(A+B+C+D >= F*.8,"Red")

Cornwalls's avatar
Cornwalls
Icon for Helper I rankHelper I
6 years ago

Thanks lbendlin 

 

Could i trouble you to walk me through that.

 

For example when i try to set up the conditional formatting, it doesnt let me put in any formula so to speak.

 

  • Cornwalls's avatar
    Cornwalls
    Icon for Helper I rankHelper I
    6 years ago

    lbendlin - in a bit more relevance to my data set. Am i creating a new measure with something like the below examples?

     

    bgcolor = if('ALL COLUMNS'[Totals Billed and Unbilled] >= ('ALL COLUMNS'[Overall Limit] *.8,"Red")

     

    =IF(('All Columns'[Overall Limit])>('All Columns'[Totals Billed and Unbilled])*80%,"greater","less")