Forum Discussion

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    cocoloco79 , Create a measure like below and use that in conditional formatting using the field value option

     

    Switch( True() ,

    Max(Table[status])=  "Planned" && [Age measure] >=7 , "Green",

    "White"

    )

     

    Use this measure in conditional formatting using the field value option

    How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

     

  • cocoloco79's avatar
    cocoloco79
    Helper III
    4 years ago

    amitchandak , thank you. I created the AgeMeasure, however using the AgreMeasure along with the switch Measure, currupts the table (marked in red)

    AgeMeasure = SUMX(BI_Planting, DATEDIFF(BI_Planting[DatePlanted], TODAY()-2, DAY))
    and then I'm using the measure below , with the created age measure.
    AlertPlanting = Switch( True() ,
    Max(BI_Planting[PlantingStatus])= "Planned" && [AgeMeasure] >=7 , "Green",
    "White"
    )
     
    I know how to create a new calculated column but stuck doing the same with a measure. What am I doing wrong here?
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi cocoloco79 ,

     

    Unfortunately, row conditional formatting is not available right now, you need to conditionally format each value in the matrix and field in the table.


    You can help us improve PowerBI by submitting an idea.
    Submit an idea

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data