Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi
May I know how to set to change font color as long as the percentage is negative? The formula input is not working.
Thank you
Solved! Go to Solution.
Hi @bbsin
First of all, Just as @lbendlin (Thanks for your contribution to the Forum) said, The 100%( = 1) but not 100(=10000%).
Then you can also realize the target with dax:
I create a set of sample data:
Then add a measure:
Color = IF(MAX('Table'[Column1])=1,"blue","red")
And right-click the field of the table visual:
Conditional formatting > Font color
Select Field value in Format style Multi-check box, then choose the color measure in the What field should we base this on?
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bbsin
First of all, Just as @lbendlin (Thanks for your contribution to the Forum) said, The 100%( = 1) but not 100(=10000%).
Then you can also realize the target with dax:
I create a set of sample data:
Then add a measure:
Color = IF(MAX('Table'[Column1])=1,"blue","red")
And right-click the field of the table visual:
Conditional formatting > Font color
Select Field value in Format style Multi-check box, then choose the color measure in the What field should we base this on?
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |