Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |