Conditional Formatting Not Working

[Anonymous]

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

@edhans 

[DataVitalizer]

You have to develop the first dropdown list where you have Count of Days Opened displayed

[Anonymous]

Sorry this is new to me, I am not really sure what that means

[parry2k]

@Anonymous did you tried what I mentioned.You column is a text not a number and tha'ts why you cannot sum it up. You need to outline your requirement, do you want conditional formatting on sum or on count, those are two different things.

[DataVitalizer]

@Anonymous  can you share with us a screenshot of your column like the one below

[Anonymous]

Before I try to change to whole number:

After I change to a whole number:

[Vvelarde · Accepted solution]

@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

[Anonymous]

This is exactly what I needed, thank you!!! 😁

[parry2k]

@Anonymous as I mentioned before, it doesnt matter if it is a text or number, it all depends what logic you want to apply, if you want your icons based on count then text value is fine, only need to change it to number, if your logic is based on the sum of these values. You have to be clear on your requirement and as mentioned earlier, send sample data with expected output.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

So the column is stored as text for some reason, so when I try to covert it to whole number I get the error "Cannot convert value '' of type Text to type Integer."

[parry2k]

@Anonymous seems like we are over complicating the things here. Why not you share raw data or your pbix file, remove sensitive information before sharing and explain wht you want, and I'm sure someone will able to get you the solution asap. You can share using onedrive/google drive or you can send me directly on my email address given in my signature.

[Anonymous]

So I think it is becuase the column is stored as text for some reason, so when I try to covert it to whole number I get the error "Cannot convert value '' of type Text to type Integer."