Forum Discussion
Solved
data colors
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?
Please see THIS BLOG for the formatting options in powerbi.
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