data colors

[rfway]

I am wanting to do a line graph of 180 companies, and want 179 of those to be black and my company to be red..is there an easy way to change all the colors at once?

[Anonymous]

Hi @rfway,

I'd like to share you a simple way to achieve your requirement.

Add a calculate column:

Type = if(LASTNONBLANK(Sheet1[User],[User])="User1","My Company","Other")

Drag this calculate column to legend and modify data color.

 

Regards,

Xiaoxin Sheng

[BhaveshPatel · Accepted solution]

Please see THIS BLOG for  the formatting options in powerbi.