Forum Discussion
Card Conditional Formatting Measure Percentage
First, create a measure that returns color based in %
Measure = if([KPI %]<50,"red","green")
In card Go to the background color and hover, you will see three dots, click and choose conditional formatting.
Then choose field in the selection and this measure
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Thank you for the prompt reply! I have done exactly as you said, but when I go to put the new measure in the conditonal format it won't let me select it. So I attempted to add the measure to the card just to test what it returns and get the below error
Thank you 🙂
In your measure calc, you seem to have appended % for formatting. Have one measure without that and use of use the text
like >"90%"
You are a saint!
Thank you very much