color formatting for decomposition tree

[dgdgdg122db]

Hello there ,

I would like to assign different colors to bars base on the Index number. For example employees with Index number =1 , have red color, and with Index number =2 , then blue color, etc. 

My current measure is incorrect.

Does anyone know how to do that?

Thanks in advance,

[Anonymous · Accepted solution]

Hi  @dgdgdg122db ,

In this visual, Count will be automatically performed, so the above 16 or 4 are the data obtained by Count, which has nothing to do with index, so it will not work when performing measure conditional formatting.

You need to put the Idex column into it, and set it through Conditional formatting:

Result：

The [Index] column will display the correct color

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly