Highlight Changes between different columns for a matrix

[Anonymous]

Hi,

I have a car manufacturing dataset which looks like this

Config ID	Feature Group	Feature Subgroup	Part No	Part Desc
12345 DCA1	Basic	Basic Machine	1	Basic Machine,Chasis
12345 DCA1	Dashboard	AC Vent	2	AC Parts, Plastic, AC Gas
12345 DCA1	Dashboard	Steering	3	Leather, Ring, Buttons
12345 DCA1	Dashboard	Indicator	4	Plastic,Connectors
12345 DCA1	Tyre	Rubber	5	Tyre,Puncture Liquid
12345 DCA2	Basic	Basic Machine	1	Basic Machine,Chasis
12345 DCA2	Dashboard	AC Vent	2	AC Parts, Plastic, AC Gas
12345 DCA2	Dashboard	Steering	3	Leather, Ring, Buttons
12345 DCA2	Dashboard	Indicator	4	Plastic,Connectors
12345 DCA2	Tyre	Rubber	5	Tyre,Puncture Liquid
12345 DCA2	Other	Lights	6	Headlamps,Tail-lamps,Sidelamps
12345 DCA3	Basic	Basic Machine	1	Basic Machine,Chasis
12345 DCA3	Dashboard	AC Vent	2	AC Parts, Plastic, Eco Gas
12345 DCA3	Dashboard	Steering	3	Leather, Ring, Buttons
12345 DCA3	Dashboard	Indicator	4	Plastic,Connectors
12345 DCA3	Tyre	Rubber	5	Tyre,Puncture Liquid
12345 DCA3	Other	Lights	6	Headlamps,Tail-lamps,Sidelamps

Out of the above dataset, I have created a Power BI Matrix as below : 

Problem Statement : 

Highlight the changes between different  Config IDs.

Eg1 

from 12345 DCA1 to 12345 DCA2(see highlighted text which was not there in 12345 DCA1 but added in 12345DCA2)

Eg 2

Then highlight the change between 12345 DCA2 and 12345DCA3(AC Parts,Plastic,Eco Gas which was a modification)

Note:

1 Config IDs can changed based on filters not shown in the example.

2 Actual dataset is huge with lot more values in each of the columns.

[v-yuta-msft]

@Anonymous ,

So your requirement to highlight the first different Part Desc from lower Config ID to higher Config ID automatically, right. I'm afraid matrix only have conditional formatting which only has simple condition function like less than, more than.

Regards,

Jimmy Tao

[Anonymous]

I was trying to work on a DAX that would throw me 0 or 1 as an output indicating change or no change. That output can be thrown on the conditional formatting for the respective attribute(Part Desc)

Any help around the same would be great