Forum Discussion
Conditional Formatting Not Working
Anonymous
Yeahh, you have Row with Spaces in that column you need to cleaned before.
One way is create a new Column :
DaysOpennedModified=IF(ISERROR(VALUE('HR'[Days Openned])),BLANK(),'HR'[Days Openned]) , now this column you can change to Whole Number.
Regards
Victor
Thank you Vvelarde
I tried this, when I try to covert it to whole number I get the error "Cannot convert value '' of type Text to type Integer."
Any suggestions?
Thanks
Super UserAnonymous Vvelarde i'm unable to understand why it is relvent to convert it to number without knowing what is the requirement. Anonymous you have to help us to get help.
The requirement is that I have a table vizualization that I would like to conditionally format one column to display an amber exclamation point if the value that is in the column is greater than 14 and less than 31, and display a red X if the value is greater than 31. Based on SUM not COUNT
- parry2k
Anonymous in your original post image you were using count and that's why I was asking. Answer thsi question if your data is like this. (always share data) to explain
Day Number
10
10
10
20
20
20
30
So do you want compare 10, 20, 30 with your condition or you want to compare sum of 10+10+10 = 30, 20 + 20 +20 (60 ) and 30. these are two different things.
- parry2k
Anonymous this is my last message on this topic, because I don't think I can help, until you can share your pbix file (ofcourse remove sensitive information before sharing) otherwise we will keep on going in circles. Sorry buddy. There are tons of awesome people who can help.