Forum Discussion

rajdba2023's avatar
rajdba2023
Frequent Visitor
2 years ago
Solved

Conditional Formatting using pre-defined RAG thresholds

Hi,   I am new to Power BI and we are migrating from another BI tool to Power BI.   We have a requirement: Transaction Table: ID, Value 1,10 1,20 1,15 2,10 3,15 3,22   RAG Threshold: I...
  • lbendlin's avatar
    2 years ago

    your RAG table is not in a usable format.

     

    Unpivot it and while doing that also change the color names so they can be used directly.

     

     

    Then create your color measure

     

    and apply the conditional formatting