Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I don't understand how make this kind of rules working.
I'm just trying tu make the text gree if the valueit's over 0, and red if it's under.
Thanks for any further suggestions.
AG
Solved! Go to Solution.
Change two things:
1) The order of the clauses (first you should evaluate for those less than 0).
2) The first dropdown should be Number, not percentage.
See example:
Proud to be a Super User!
Hi, @AndreaCBS
I have the following matrix:
It is suggested that you can create a metric similar to the following:
Measure 2 = IF(SUM('Table'[count])>40,"green","red")
This metric will be used in the conditional format of the matrix
The results are as follows:
Best Regards,
hackcrr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Change two things:
1) The order of the clauses (first you should evaluate for those less than 0).
2) The first dropdown should be Number, not percentage.
See example:
Proud to be a Super User!
Thanks for your help!
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
67 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |