Forum Discussion

cooksteve09's avatar
cooksteve09
Frequent Visitor
4 years ago
Solved

Conditional Formatting using calculated measure

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 

 

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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"
    )

     

     

     

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    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's avatar
      cooksteve09
      Frequent Visitor
      4 years ago

      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's avatar
        V-lianl-msft
        Community Support
        4 years ago

        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"
    )

         

         

         

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

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