Conditional formatting of table visual with prior and current users, roles and reviewer.

[Lahari]

Hi Amitchandak,

I have an excel file of having input table as follows, 

UserName	Role Name	Reviewer	Row_Load_Date	Company name	Status	RLD
A	AA	JIM	06/18/2023	A1	ACTIVE	20230618
B	BB		06/18/2023	A1	ACTIVE	20230618
B	BBB		06/18/2023	A1	ACTIVE	20230618
C	CCC		06/18/2023	A2	ACTIVE	20230618
D	DD		06/18/2023	A2	ACTIVE	20230618
D	DDD		06/18/2023	A2	ACTIVE	20230618
E	EE	JACK	06/18/2023	A3	ACTIVE	20230618
E	EEE		06/18/2023	A3	ACTIVE	20230618
F	FFF		06/18/2023	A3	ACTIVE	20230618
G	GGG		06/18/2023	A3	ACTIVE	20230618
A	AA	HAN	06/19/2023	A1	ACTIVE	20230619
C	CCC	JACK	06/19/2023	A2	ACTIVE	20230619
D	DD	ROSE	06/19/2023	A2	ACTIVE	20230619
D	DDD	JOHN	06/19/2023	A2	ACTIVE	20230619
E	EE	JOHN	06/19/2023	A3	ACTIVE	20230619
E	EEE	ROSE	06/19/2023	A3	ACTIVE	20230619
F	FFF	FIN	06/19/2023	A3	ACTIVE	20230619
G	GGG	FIN	06/19/2023	A3	ACTIVE	20230619
A	AA	HAN	06/20/2023	A1	ACTIVE	20230620
D	DD	ROSE	06/20/2023	A2	ACTIVE	20230620
D	DDD	JOHN	06/20/2023	A2	ACTIVE	20230620
E	EE	JOHN	06/20/2023	A3	ACTIVE	20230620
E	EEE	ROSE	06/20/2023	A3	ACTIVE	20230620
F	FFF	FIN	06/20/2023	A3	ACTIVE	20230620
G	GGG	FIN	06/20/2023	A3	ACTIVE	20230620

I have taken this input file into the power bi desktop and i am not getting the output as expected as follows 

prior usersprior rolescurrent userscurrent rolescurrent reviewer

in slicer when rld of prior period selected is 06/18/2023
in slicer when rld of current period selected is 06/19/2023
expected outpout in table visual of power bi is
prior user	prior role	current user	current role	current reviwer
A	AA	A	AA	HAN
B	BB
B	BBB
C	CCC	C	CCC	JACK
D	DD	D	DD	ROSE
D	DDD	D	DDD	JOHN
E	EE	E	EE	JOHN
E	EEE	E	EEE	ROSE
F	FFF	F	FFF	FIN
G	GGG	G	GGG	FIN

but i am getting the output as follows 

Prior User NamePrior Role NameCurrent UserName Current Role NameReviewer 

unexpected ouptut I got in table visual of power bi
prior user	prior role	current user	current role	current reviewer
A	AA	A	AA	HAN
A	AA	A	AA	JIM
B	BB	B	BB
B	BBB	B	BBB
C	CCC	C	CCC
C	CCC	C	CCC	JACK
D	DD	D	DD
D	DD	D	DD	ROSE
D	DDD	D	DDD
D	DDD	D	DDD	JOHN
E	EE	E	EE	JACK
E	EE	E	EE	JOHN
E	EEE	E	EEE
E	EEE	E	EEE	ROSE
F	FFF	F	FFF
F	FFF	F	FFF	FIN
G	GGG	G	GGG
G	GGG	G	GGG	FIN

i am inserting the image as well for your refernce 

input file

the ouput files which is shown in excel what am i expecting and what i got 

the pbix file images also i am inserting for your refernece

Please help me in solving this issue. I am expecting positive response from your end. Thanks in advance.