Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dears,
i have this DAX formula and it shows as text because it contains % and Value in the same column
I need to color in read the text in negative
Solved! Go to Solution.
You can create a measure to format.
Format = IF(CONTAINSSTRING([Margin Gap],"-"),"red","green")
Then put it to the conditional formatting of the [Margin Gap] measure, select font color.
Then set the condition.
Output
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.
Thanks
You can create a measure to format.
Format = IF(CONTAINSSTRING([Margin Gap],"-"),"red","green")
Then put it to the conditional formatting of the [Margin Gap] measure, select font color.
Then set the condition.
Output
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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |