Add color per value in a column

[Anonymous]

Hi, i want to add a different color for the whole table based on different values on the values with C1H.  So al lines with C1H014874 should have a different color then the lines with C1H016378.

Can someone help me?

[Arul]

@Anonymous ,

try to create the condition in measure and apply conditional formatting.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Thanks,

Arul

[Arul · Accepted solution]

@Anonymous ,

try this in conditional formatting

Thanks,

Arul

[Anonymous]

Hi arul,

Thanks for your answer. You have done it manually now by filling in the right C1H number. I want that al different C1H numbers have differrent colors, or at least that it becomes very clear when a new C1H number starts.

[Arul]

@Anonymous ,

Are you expecting this?

Thanks,

Arul

[Anonymous]

No, all my numbers start with C1H but when a next c1h number starts i want to it to be very clear that is is a other number!

[Arul]

@Anonymous ,

Do you want to show different background colors for all the rows?

Thanks,

Arul

[Anonymous]

@Arul 

I want to have a different background color when a new C1H number starts!

[Arul]

@Anonymous ,

How can we identify whether that particular C1H number starts new? Is there any flag column available?

Thank,

Arul

[Anonymous]

For example, first number is C1H10014 that number has 4 lines. Then C1H14874 starts. I want the 4 lines with C1H10014 to have a different color than the C1H14874 bc it is another value