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
Go to Solution.
Background colour =
[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.
View solution in original post
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.
Proud to be a Super User!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!