Forum Discussion
New Card - Conditional Formatting the Detail Label Which Contains a Measure
- Anonymous2 years ago
After testing, in card cannot set the icon color, you can consider to use the kpi visual.
put the [Total Number of Problems Closed] measure to the value, then put the [Problems Closed in Previous Month] to the target, in trend axis, you can put year or other field.
Then when filter the slicer, you can refet to the following picture.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To change the arrow color in your New Card visual
You can add HTML formatting to your measure to control the color directly
Problems Raised =
VAR Up_Arrow = "<span style='color:green'>" & UNICHAR(129137) & "</span>"
VAR Down_Arrow = "<span style='color:red'>" & UNICHAR(129139) & "</span>"
VAR lastmonth = [Problems Closed in Previous Month]
VAR total = [Total Number of Problems Closed]
RETURN
IF(total > lastmonth, Up_Arrow, Down_Arrow)
or Alternatively, create two separate measures—one for color and one for the arrow—and then use conditional formatting based on the color measure in the New Card visual.