Conditional Color Scorecard Text w Alphanumeric characters.

[sa34techer]

My data has has a letter "X", in the Wait Time column which stands for "Closed".    I want to set the text color X to red in a scorecard, also use the number ranges below, too.  Please help me achieve this.  Datatype comes out as Text cause of the X. 

Open/Closed	Wait Time
OPEN	14
CLOSED	X
OPEN	17
OPEN	4
OPEN	3

         HOW TO SET X TO RED?

[rsbin · Accepted solution]

@sa34techer ,

You recognize that Power BI does not handle mixed data in the same Column.

You can handle this in a couple of different ways.

1.  Use Power Query to replace "X" with a -ve number (-1,-99 or such).  Then your Column becomes a whole number or decimal column.  Then proceed to use your conditional formatting.

2.  Alternatively, you can create another Calculated Column to contain records that are "Closed" ( = "X")

Then your Wait Time column becomes a number column and you can easily identify Closed Records via this new column.

Hope you get the gist of these thoughts and leads you to an appropriate solution.

Regards,