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.
Hi Guys
I keep hitting a brick wall, I have this formula but I keep getting errors OR it only picks up the first condition "Green" and the "Persian Blue" for all my completed items.
I am trying to do is get all information marked as complete with "Persian Blue", if it is not marked as complete I need a colour name on the basis of the % of budget used on the work
Solved! Go to Solution.
Hi @ALemmy
Background colour =
SWITCH (
TRUE (),
[DAX Status] = "Complete", "Persian Blue",
AND ( [% remaining - Report] >= 0, [% remaining - Report] < 0.4 ), "Green",
AND ( [% remaining - Report] >= 0.41, [% remaining - Report] < 0.6 ), "Lemon",
AND ( [% remaining - Report] >= 0.61, [% remaining - Report] < 0.79 ), "Orange",
[% remaining - Report] > 0.8, "Red"
)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
@ALemmy ,
Check this - https://community.powerbi.com/t5/Community-Blog/Conditional-Formatting-Using-Custom-Measure/ba-p/139... if this helps you.
You can set the MIN and MAX values according to your requirement.
Appreciate your kudos!! Please mark my post as solution if this suits your requirement.
Hi @ALemmy
Background colour =
SWITCH (
TRUE (),
[DAX Status] = "Complete", "Persian Blue",
AND ( [% remaining - Report] >= 0, [% remaining - Report] < 0.4 ), "Green",
AND ( [% remaining - Report] >= 0.41, [% remaining - Report] < 0.6 ), "Lemon",
AND ( [% remaining - Report] >= 0.61, [% remaining - Report] < 0.79 ), "Orange",
[% remaining - Report] > 0.8, "Red"
)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |