Conditional Formatting Help

Helper II

2 years ago

parry2k Apologies for the same.
There are multiple measures i have used and there are too many columns, hence i have avoided to inculde.

To get the % of score i have used below measure

To get the Level1 & Level2, i have used below measure(Last characters is of first column of table"Severity"), as was not table to extract the text value.

below is the logical measure i am trying to use to get the conditional formatting value

TableName:-DG Audit Reports

Severity	Compliance(Y, N, N/A)	Compliant Level 1 =6Level 2 = 2	Non-Compliant Level 1 = -12Level 2 = -2	N/ALevel 1 = -6Level 2 = -2	Site Reviewed	Review Date	CalRef	Non_C_Ref	N	N/A	Year	Month	Last Characters	FileName	H1_H2
Level 2	Y	2			AMD VJR	08-Jul-23	2				2023	7	2	AMDVJR_H2_2023.xlsm	H2
Level 2	Y	2			AMD VJR	08-Jul-23	2				2023	7	2	AMDVJR_H2_2023.xlsm	H2
Level 2	Y	2			AMD VJR	08-Jul-23	2				2023	7	2	AMDVJR_H2_2023.xlsm	H2
Level 2	Y	2			AMD VJR	08-Jul-23	2				2023	7	2	AMDVJR_H2_2023.xlsm	H2
Level 2	Y	2			BLR HSR	11-Jul-23	2				2023	7	2	BLRHSR_H2_2023.xlsm	H2
Level 2	Y	2			BLR HSR	11-Jul-23	2				2023	7	2	BLRHSR_H2_2023.xlsm	H2
Level 2	Y	2			BLR HSR	11-Jul-23	2				2023	7	2	BLRHSR_H2_2023.xlsm	H2
Level 2	Y	2			BLR HSR	11-Jul-23	2				2023	7	2	BLRHSR_H2_2023.xlsm	H2
Level 2	Y	2			BLR MDY	25-Jul-23	2				2023	7	2	BLRMDY_H2_2023.xlsm	H2
Level 2	Y	2			BLR MDY	25-Jul-23	2				2023	7	2	BLRMDY_H2_2023.xlsm	H2
Level 2	Y	2			BLR MDY	25-Jul-23	2				2023	7	2	BLRMDY_H2_2023.xlsm	H2
Level 2	Y	2			BLR MDY	25-Jul-23	2				2023	7	2	BLRMDY_H2_2023.xlsm	H2
Level 2	Y	2			BLR MYQ	15-Jul-23	2				2023	7	2	BLRMYQ_H2_2023.xlsm	H2
Level 2	Y	2			BLR MYQ	15-Jul-23	2				2023	7	2	BLRMYQ_H2_2023.xlsm	H2
Level 2	Y	2			BLR MYQ	15-Jul-23	2				2023	7	2	BLRMYQ_H2_2023.xlsm	H2
Level 2	Y	2			BLR MYQ	15-Jul-23	2				2023	7	2	BLRMYQ_H2_2023.xlsm	H2
Level 2	Y	2			BLR YPU	08-Jul-23	2				2023	7	2	BLRYPU_H2_2023.xlsm	H2
Level 2	Y	2			BLR YPU	08-Jul-23	2				2023	7	2	BLRYPU_H2_2023.xlsm	H2
Level 2	Y	2			BLR YPU	08-Jul-23	2				2023	7	2	BLRYPU_H2_2023.xlsm	H2
Level 2	Y	2			BLR YPU	08-Jul-23	2				2023	7	2	BLRYPU_H2_2023.xlsm	H2
Level 2	Y	2			BOM BYO	07-Jul-23	2				2023	7	2	BOMBYO_H2_2023.xlsm	H2
Level 2	Y	2			BOM BYO	07-Jul-23	2				2023	7	2	BOMBYO_H2_2023.xlsm	H2
Level 2	Y	2			BOM BYO	07-Jul-23	2				2023	7	2	BOMBYO_H2_2023.xlsm	H2
Level 2	Y	2			BOM BYO	07-Jul-23	2				2023	7	2	BOMBYO_H2_2023.xlsm	H2
Level 2	Y	2			BOM GG1	08-Jul-23	2				2023	7	2	BOMGG1_H2_2023.xlsm	H2
Level 2	Y	2			BOM GG1	08-Jul-23	2				2023	7	2	BOMGG1_H2_2023.xlsm	H2
Level 2	Y	2			BOM GG1	08-Jul-23	2				2023	7	2	BOMGG1_H2_2023.xlsm	H2

If post allows me to attached file, then i would have did that.
Thanks

Forum Discussion

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting