Forum Discussion
Conditional Formatting Not Working
Hello all,
First off I am new to Power BI so if this is a simple explanation I apoligize. I tried googling and could not really find a solution.
I have a table vizualization that I would like to conditionally format one column to display an amber exclamation point if the value is greater than 14 and less than 31, and display a red X if the value is greater than 31. I have enetered the parameters to do this (or so I thought) and it seems to do nothing. Please see screen shot.
Any help is much appreciated!
TIA
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
31 Replies
Anonymous can you remove first blank() condition and then check, wondering if you are having blank values.
Anonymous can you drop your measure that one you are using for conditional formatting in a table visual and see what result you are getting. without seeing the data it is hard to say what is going on.
my conditional formatting not working for column however same formatting working fine for another column with same data type
I have used Divide() function to arrive at % value
Anonymous
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
