Forum Discussion
Conditional formatting Text count based as a % on the column total
SloeMo No, not because it is text because you have the Count aggregation. But, what you need to be using is the %GT of Count of KRI Category. Of course, you probably don't have that available in the conditional formatting stuff. But, you could create a measure like:
GT % Measure = VAR __Count = COUNT('Table'[Count of KRI Category) VAR __AllCount = COUNTX(ALL('Table'),[Count of KRI Category]) RETURN DIVIDE(__Count,__AllCount,0)
SloeMo You should be using the Number dropdown and not Percent. Should be something like if > 0 and <= .45 and > .45 and <= 1
Or something like that.
thanks Greg_Deckler
I had tried that previously based on other threads but these are the results.
Am I doing something wrong in the format, it looks like as I am using number as a rule nothing actually falls into the rule parameter as the actual lowest count in the data is 2. I need it work from a % as the numbers will change.
Didn't know if this is because the column is text?
Thanks
Lee