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
Community ChampionAnonymous
Hi, the key is your Data Type's Column. You see numbers but in the data model are declare it like String / Text Type.
To change to Number Data Type please follow this:
Select your column from Fields (Right Panel) , Go To Modeling --Data Type --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
- parry2k
Super User
Anonymous 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.
- Vvelarde
Anonymous
I will checked if your columns Days Open had Text Character in any row , like Letters, Spaces or anything that can't transform in Integer Type.
