Forum Discussion
Conditional Formatting using calculated measure
Please try:
Column = var current_ = 'Table'[Index] var next = current_+1 var base_line = MAX('Table'[Index]) var current_value = 'Table'[filled] var next_value = CALCULATE(SUM('Table'[filled]),FILTER('Table','Table'[Index]=next)) return SWITCH(TRUE(), 'Table'[Index]=base_line,"black", current_value>next_value,"green", current_value<next_value,"red", current_value=next_value,"blue" )
cooksteve09 your last statement should be
SWITCH ( TRUE(),
Current_Value > Previous_Value, "Green",
Current_Value < Previous_Value, "Red",
"Blue"
)
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡
Thank you parry2k but its not quite right
Step 2 should be green because its greater then step 3 and step 3 should be blue because its equal to step 4, step 4 should be green because its greater then step 5 and step 5 should be black because thats the base line
does that make sense? any idea how i get it to work that way?
Please try:
Column = var current_ = 'Table'[Index] var next = current_+1 var base_line = MAX('Table'[Index]) var current_value = 'Table'[filled] var next_value = CALCULATE(SUM('Table'[filled]),FILTER('Table','Table'[Index]=next)) return SWITCH(TRUE(), 'Table'[Index]=base_line,"black", current_value>next_value,"green", current_value<next_value,"red", current_value=next_value,"blue" )Thank you, this is almost perfect except the baseline is only applying to the largest number of one ID, i need it to apply to each ID's largest Step number....tried several things but i just cant quite get the DAX right
