1 Comment

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago
    Status changed:
    New
    to
    Done

    Hi checkers65 ,

    In the original post, Padycosmos provide a new workaroud, it also works by my test.

    color =
SWITCH (
    TRUE (),
    SUM ( 'Table'[Sales] ) >= [Target Sales] * 0.8, "Green",
    "red"
)

    If you still prefer the option in the previous version, you may create an idea in the idea forum to improve this feature. It is a place for customers provide feedback about Microsoft Office products. What's more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best regards,

    Community Support Team_kalyj

Completed Ideas