Conditional Formatting Power BI

[Pranvanand]

Hello Peers @rajendraongole1 @lbendlin @Poojara_D12 , 

I tried all the standard conditional formatting for the following table for the cloloumn quanity but couldn't rech to a solution. Can anybody help me in the following scenario? I am not good at DAX.

The conditional formatting in coloumn Quantity is based on min and max whicht is different for the each department. I want following color coding. For each depatment, if the quantity is smaller than min then "Red" or greater than max then "Red" & if the quanity falls between or equal to min and max  then "Green".

Quantity value  smaller than min or greater than max
Quantity Value in between or equal to min and max
Dapertment number	Quantity	Number of Orders	Min	Max
11A	30	2	10	50
12B	80	3	50	70
13C	110	4	80	150
14D	10	5	30	50

[v-yohua-msft]

Hi, @Pranvanand 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yongkang Hua

[Pranvanand]

Hi @lbendlin ,

Thank you very much for your help.

For some of the feilds its not working. Have I done somwthing wrong here?

I creadted a measure and under conditional formating, I can not select the Color gradient so I chose Field value and the measure color.

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Pranvanand]

Hi @lbendlin

As following is my data

As per attached image I want conditions color coding for this. 

Department	Quntity	Orders	Min	Max
911950	1	1	800	1000
911936	3	1	5	400
912290	5	1	800	1000
91122K	8	2	5	400
91132N	8	1	800	1000
91263E	8	2	800	1000
91222H	10	1	5	400
912290	10	1	5	400
91134C	18	2	800	1000
911500	18	1	800	1000
91132F	20	1	10	30
91363B	20	1	5	400
912390	30	2	800	1000
912300	31	1	800	1000
91132K	32	4	800	1000
91134C	33	4	5	400
913620	34	2	800	1000
91363C	34	2	800	1000
91170B	35	2	800	1000
91222H	35	3	800	1000
91281B	40	1	800	1000
91132H	41	3	25	100
91226B	44	3	800	1000
91281B	44	3	5	400
91132I	47	5	15	150
919142	52	23	800	1000
913620	60	1	5	400
91190A	71	15	800	1000
91132I	79	6	15	100
91363C	79	2	5	400
91134D	80	2	800	1000
919110	82	9	800	1000
91D105	89	1	800	1000
91268B	90	6	5	400
911300	96	33	800	1000
91222G	100	1	5	400
91132M	144	12	5	400
91192I	145	6	5	400
91226B	146	10	5	400
913810	150	3	5	400
912400	156	3	5	400
91268A	165	11	5	10
91222C	176	13	800	1000
913650	180	5	800	1000
912390	186	13	5	400
91222J	189	7	800	1000
911500	192	13	5	400
919142	223	5	5	400
91122G	223	12	800	1000
911200	232	55	800	1000
91168C	238	22	5	400
911827	240	7	5	400
91263C	240	16	5	400
91268C	255	17	5	400
911300	256	8	5	400
91122I	260	12	800	1000
91168C	270	9	800	1000
91132N	285	20	5	400
91122L	288	12	5	400
91122J	289	16	800	1000
912207	310	9	800	1000
91192I	331	7	800	1000
91190B	349	7	5	400
91363A	355	9	5	400
912250	363	6	800	1000
91222B	400	2	5	400
91263D	410	8	800	1000
91222G	418	8	800	1000
91232L	428	4	5	400
919101	440	25	800	1000
913690	453	30	5	400
912600	467	8	5	400
911936	490	21	800	1000
911921	521	12	5	400
91222A	530	8	5	400
913660	548	17	5	400
91222C	552	18	5	400
91132K	555	68	5	400
91232N	558	13	5	400
91122K	561	28	800	1000
91190B	565	50	800	1000
91222K	574	11	800	1000
919101	619	9	5	400
91222D	684	5	5	400
91122G	701	30	5	400
913690	742	27	800	1000
913600	838	269	800	1000
912240	863	8	5	400
91363A	888	35	800	1000
912520	903	15	5	400
912920	918	27	800	1000
919185	933	15	800	1000
912610	937	15	5	400
919110	979	95	5	400
91170B	1135	29	5	400
912600	1138	30	800	1000
91122I	1166	97	5	400
911921	1186	86	800	1000
912100	1344	62	800	1000
912190	1357	39	800	1000
911915	1374	97	800	1000
912920	1943	72	5	400
91D105	2028	103	5	400
911200	2199	70	5	400
911930	2344	130	800	1000
919100	2361	276	800	1000
91D100	2425	121	5	400
91222K	2844	38	5	400
912945	2888	16	5	400
911825	3132	107	800	1000
91170C	3477	162	800	1000
91122J	3543	70	5	400
91170C	4317	170	5	400
912250	4476	32	5	400
911945	4765	118	800	1000
911910	5004	224	800	1000
911920	5091	146	5	400
911910	5410	68	5	400
911930	5476	64	5	400
91D100	6004	216	800	1000
911915	7467	157	5	400
913600	7631	437	5	400
911920	8515	170	800	1000
912100	9250	118	5	400
919100	10577	61	5	400
911825	11818	132	5	400
913640	12360	5	5	400
911945	57895	537	5	400

[lbendlin · Accepted solution]

Same approach. Note I corrected the typo.

[Pranvanand]

Thank you very much for your help and I accept this as a solution.

[lbendlin]

Color = if(sum('Table'[Quantity ])<sum('Table'[Min ]) || sum('Table'[Quantity ])>sum('Table'[Max]),"red","lightgreen")

Use the Color measure value for the background color.