Card - Conditional Formatting

[Anonymous]

Hi, 

I am trying to get the conditional formatting to work on my cards.  I am looking at Inventory data and have Age Buckets that have goals associated with it:

I am currently working on the 151 to 180 bucket.  The current percent of the Inventory that is in the bucket is 5.52%

When I try to use the Rule format style and use the logic below:

The resulte is in black: 

I have also tried to to use the number variation of 5 and 100, but it is the same.  I am not sure why the coloration is not switiching accordingly.  

I have also tried to use the Gradient formatting style and am having a similar issue:

Again, same issue.  The coloration is not correct. I have also, again, tried the whole numbers and having the same issue.  

Any help is welcome! Thank you in advance.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Please download this example PBIX file

Not sure how you are calculating your buckets, see my file for what I've done.

But, if you do something like this

151 to 180 = DIVIDE(CALCULATE(COUNTROWS('DataTable'), FILTER('DataTable', 'DataTable'[Aging Bucket] = "151 to 180")), COUNTROWS(ALL('DataTable')))

Then set up the card and go into the CF rules

It works for me

Regards

Phil