Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sa34techer
Helper II
Helper II

Conditional Color Scorecard Text w Alphanumeric characters.

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/ClosedWait Time
OPEN14
CLOSEDX
OPEN17
OPEN4
OPEN3

 

 

         HOW TO SET X TO RED?

sa34techer_1-1737654768063.png

 

 

 

 

 

sa34techer_0-1737654544859.png

 

1 ACCEPTED SOLUTION
rsbin
Super User
Super User

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

View solution in original post

1 REPLY 1
rsbin
Super User
Super User

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.