Conditional Formatting using calculated measure

[cooksteve09]

Please help!!

What i am after seeing in the "If_Red" column is, if the value has increased on previous week then green, red if decrease and blue if equal, below is an example of my data and my calculated column so far

Im not great at writing dax so any help would be greatly appreciated

Thanks in advance

Conditional formatting based on % of another column Calculated Column 

[parry2k]

@cooksteve09 Just tweak the condition in the switch function based on your logic and it should work, you can add more conditions as per the business logic, not sure if you are unable to do that basic value condition stuff. You have the ides in the solution, just tweak it.

✨ 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.⚡

[parry2k]

@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.⚡

[cooksteve09]

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?

[V-lianl-msft · Accepted solution]

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]

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