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
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
Dear amitchandak,
I am quite newbie, I am starting Power BI since 7 days ago and I am using Power BI Desktop, September 2022 update.
Suppose if I want to apply conditional formatting in a card, how to do that? if the % of "Open" issues >=25% then font color will be in red, else font color is green.
I have a mesure to find the percentage of "Open" issues, as below: the current number is 47%
Open percent =
FORMAT(DIVIDE([Count Open item],[Count total item]),"0%")And I have another measure as your suggestion above, for conditional coloring background.
Condition format open =
IF([Open percent]>=25,"red","green")
What the next step should I do?
Thank you very much.
Prima Indonesia