Forum Discussion
Icons Conditional Formatting
Anonymous choose cpi color 2 on based on the field, and then put the rules for 0 to show red circle or whatever you want to show..you are not sharing full rule screen, I don't know how you expect me to understand what you are doing from half of the screenshot. I have no magical way to figure out the rules
Anonymous hmmm circle are icons conditional formatting, so based on the value you choose what icon to show, instead of color, return value 0 or 1 and on 0 let's say show green circle and on 1 show red circle.
eNPS color = if('Employee NPS'[Employee NPS]<sum('Targets'[Employee NPS target]),0,if('Employee NPS'[Employee NPS]>sum('Targets'[Employee NPS target]),1))
Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
In the gauges i am using conditional formatting, format by field color, using this value. How do i apply this? Where are 1 and 0 defined?