Forum Discussion
Conditional Formatting appears to not be working
Hi TBStacey ,
Please try this:Measure = SWITCH( TRUE(), [Percent]>=0.81&&[Percent]<=1,"Green", [Percent]>=0.5&&[Percent]<0.81,"Yellow", [Percent]>=0&&[Percent]<0.5,"Red" )and use field value format style.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi TBStacey ,
Please try this:
Measure =
SWITCH(
TRUE(),
[Percent]>=0.81&&[Percent]<=1,"Green",
[Percent]>=0.5&&[Percent]<0.81,"Yellow",
[Percent]>=0&&[Percent]<0.5,"Red"
)and use field value format style.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hello there and thank you for your idea. I am still learning, so pardon if this is a silly question. When creating the new measure, would the field name for the dataset go between the parantheses after TRUE? I.e., TRUE (dataset field name here),
That is where I put it, but I get this error, "The following syntax error occurred during parsing: Invalid token, Line 3, Offset 10, %."
Hi TBStacey ,
--When creating the new measure, would the field name for the dataset go between the parantheses after TRUE? I.e., TRUE (dataset field name here)
--The True() function always returns TRUE.
TRUE function (DAX) - DAX | Microsoft Learn
Here, three expressions are matched against TRUE, and if any expression matches first, the value following the expression is output.
SWITCH function (DAX) - DAX | Microsoft LearnBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thank you! I was able to figure out how to use the new measure based on your additional information and it worked! I appreciate your time and assistance. Have a great day!