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 

[Vvelarde]

@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

[Anonymous]

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

[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.

[parry2k]

@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.

[Anonymous]

@parry2k 

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. 

[Anonymous]

I apologize if it was confusing, this is still new to me

From you example, I want compare 10, 20, 30 with the condition.

To give some background, this column represents the number of days a job has been vacant. I so I want to flag them with Icons when they reach a certain number of days that they have been vacant.

[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.

[parry2k]

@Anonymous can you remove first blank() condition and then check, wondering if you are having blank values.

[pranlad]

my conditional formatting not working for column however same formatting working fine for another column with same data type

[pranlad]

I have used Divide() function to arrive at % value

[Anonymous]

I removed the rule related to blank values and still nothing

[parry2k]

@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. 

[Anonymous]

I added it to a new vizualization and now it is only working for a few of the values, very strange

[parry2k]

@Anonymous are you showing cout of days opened in your image which doesn't seems to be the case because it doesn't looks like a number. 

[Anonymous]

You can see on the left, Days Openned is a number in the column

[DataVitalizer]

Hi @Anonymous,

I just generated the same exmaple here below

1- Make sure to select Sum from the list based on field

2- No need to set a higher value in the second condition replace 99999 by 100 and replace number by percent

Try it and let me know your feedback 

[Anonymous]

It does not give me the option of sum, only count. How can I change it so I can have sum as an option?

[parry2k]

@Anonymous i don't it is a number but tht is not important, you haven't dropped any aggregation that you are using in condition formatting, you are missing the point here. Do following, add a measure

Days Count = COUNT ( Table[Your days column] )

in table visual, drop above measure in your visual and see what values you are getting and that is getting used for conditional formatting. 

[Anonymous]

Ahh I see, I need to change it from Count to Sum, but it wont let me select anything other than count.