Conditional formatting

[Anonymous]

Hi all,

Hope someone can help me with the following.

I have a table in my report:

quantity	order_nr	customer	container_nr	line
1	8822598	ONE	BMOU9715033	Adjusted configuration
1	8822598	ONE	BMOU9715033	Humidity sensor
1	8822598	ONE	BMOU9715033	Photo fee (for Kramer only)
1	8822598	ONE	BMOU9715033	Photo fee (RWG/Antwerpen)
1	8822504	ONE	BMOU9718855	Cable splice 1x
1	8822504	ONE	BMOU9718855	Fresh air vent cleaning
1	8822504	ONE	BMOU9718855	Photo fee (RWG/Antwerpen)
1	8822504	ONE	BMOU9718855	System to block / leaktest / vacume
1	8822504	ONE	BMOU9718855	TXV cover refit
1	8822504	ONE	BMOU9718855	Universal Drier
1	8821228	ONE	BMOU9722222	Fresh air vent cleaning
1	8821228	ONE	BMOU9722222	Operation name plate
1	8821228	ONE	BMOU9722222	Photo fee (RWG/Antwerpen)
1	8821245	ONE	BMOU9728010	HMC setting adjust
1	8821245	ONE	BMOU9728010	Humidity sensor
1	8821245	ONE	BMOU9728010	Photo fee (RWG/Antwerpen)
1	8822453	ONE	BMOU9756182	Photo fee (RWG/Antwerpen)
1	8822453	ONE	BMOU9756182	System to block / leaktest / vacume
1	8822453	ONE	BMOU9756182	Universal Drier
1	8821574	ONE	BMOU9869954	Photo fee (RWG/Antwerpen)
1	8821574	ONE	BMOU9869954	Suction sensor
1	8822493	ONE	CXRU1145529	Adjusted configuration
1	8822493	ONE	CXRU1145529	Photo fee (RWG/Antwerpen)

I want to automatically change the colour of the lines, beloning to an order_nr.

Someting like this:

Is there a way to do so in Power BI?

Thanks for your help!

John

[PhilipTreacy · Accepted solution]

HI @Anonymous 

Download sample PBIX file.

Yes but you'd need to set the conditional formatting for the background color of each field.  That is, set it separately for quantity, order_nr, customer, container_nr and line.

Alternatively, you could just set it for one of those fields to draw attention to it, like so

Check the sample file I linked to above.

Regards

Phil

[Anonymous]

Thanks! This will do the job.

Regards,

John