Conditional Formatting using pre-defined RAG thresholds

[rajdba2023]

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:

ID, Green Low, Green High, Amber Low, Amber High, Red Low, Red High

1,0,10,11,30,31,9999

2,0,5,6,20,21,9999

3,0,1,2,5,6,9999

When I so a summerized count against the ID, based on the corresponding RAG threshold we want to change the font color to Green, Amber or Red,

1, 45 (Shown in Red)

2, 10 (Shown in Amber)

3, 37 (Shown in Red)

How do I achieve this?  Tried reading through conditional formatting and can't find any lead on how to set the threshold values using another column values

Thanks

Raj

[lbendlin · Accepted solution]

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