Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |