Remove "_" and "+" and keep the conditional formatting.

ROG 

To achieve the desired outcome of removing the signs from the values while retaining the conditional formatting based on the absence of the negative sign, you can follow these steps:

1. **Remove Signs from Values**:
- In Power BI Desktop, create a new calculated column or measure (depending on where the values are stored) that removes the signs from the values.
- For example, if your original value is stored in a column named "Value", you can create a calculated column like this:
```
Abs_Value = ABS([Value])
```
- This will create a new column (or measure) that contains the absolute values of the original values, effectively removing the negative signs.

2. **Apply Conditional Formatting**:
- Now that you have the absolute values without signs, you can apply conditional formatting based on these values.
- Select the visual (e.g., table or matrix) where you want to apply the conditional formatting.
- Go to the "Format" pane for the visual.
- Find the formatting options for the column or measure where you've removed the signs (e.g., "Abs_Value").
- Apply conditional formatting based on the absolute values:
- Set the color green for values greater than or equal to zero (indicating good).
- Set the color red for values less than zero (indicating negative or bad).
- Save your changes.

By following these steps, you'll remove the signs from the values while still retaining the conditional formatting based on the absence of the negative sign. This way, you'll achieve the desired color representation (green for positive values, red for negative values) without relying on the presence of the negative sign.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!