Table conditional formating

[Anonymous]

Hi all,

I need some help with the conditional formatting:

I have this Data set:

And I performed conditional formating when some integer from the Blue color col is appear and I got this table:

Now I would like to add additional conditional formatting that all what come before the blue color will be fill with grey color like in the picture below:

There is possible? if not there is another way beside conditional formatting to perform this?

Thanks a lot!

[mussaenda]

Hi @Anonymous , can we have your sample dataset where we can copy the data to meet your requierement? 

Thank you.

[Anonymous]

HI @mussaenda , unfortunately I can't share the PBI file (because I don't have permissions to do it).
However I can send the table and you can copy it into Excel file?
Please find the detailed table:

Title	Total	New Requirement	Frist Test	Approve Test 1	Second Test	Approve Test 2	Blue Color
Task A	New Requirement	New Requirement					1
Task B	New Requirement	New Requirement					1
Task C	Approve Test 1			Approve Test 1			3
Task D	Approve Test 1			Approve Test 1			3
Task E	Second Test				Second Test		4
Task F	Approve Test 2					Approve Test 2	5

 Thanks a lot!

[mussaenda · Accepted solution]

Hi @Anonymous

This is your expected output, right?

 

pbix is attached for your reference.

Hope this helps

[Anonymous]

Thanks!! It's works!