The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |