Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Conditional Formatting based on two columns

    Posted 23 days ago
    i want to create a conditonal formatting with background color for first customer priority ( we use direct query )

    1. if currentAge < 60 and annualincome > 100,000 - priority should be green
    2.if currentAge between 60 and 70 and annualincome between 60,000 and 100,000 - priority should be orange
    3.if currentAge between > 70 and annualincome < 60,000 - priority should be red


    ------------------------------
    evano oruvan
    ------------------------------


  • 2.  RE: Conditional Formatting based on two columns

    Posted 23 days ago
      |   view attached
    You can use Switch Conditions together as below. You can just the conditions as per your requirements. Uploaded the file as well.

    Flag =
    SWITCH(
    TRUE(),
    Emp[Income] >= 100000 && Emp[Age] >=60, "Green",
    Emp[Income] >= 70000 && Emp[Age] >=55, "Yellow",
    Emp[Income] >= 50000 && Emp[Age] >=40, "Red")

    Regards,
    Pulendar V



    ------------------------------
    Pulendar vadde
    IT consultant
    ------------------------------

    Attachment(s)

    pbix
    Conditions-two.pbix   28 KB 1 version