Conditional Color formatting with different values on same table

[Anonymous]

Hi guys,

I think my two questions are so simple, but i'm on stuck with them both. I have a table like the image below.

Also, I have diferents objectives for differents letters like.. A=1, B=1,5 or C=2. So.. for the first table, how can I put 2 colors (red or green) based if my objectives are up or down by the fixed value (A=1, etc..) ?

I tried by myself with the conditional colors but i'm not been able to do that.

For the second table is the same like table 1 but the objectives for letters will be change based on years.

Thanks a lot in advance,

Best regards,,

Werpov

[TeigeGao]

Hi @Anonymous ,

According to your description, my understanding is that you want to format the cell color based on the value of multiple columns, based on my researching, PowerBI doesn't support this since now. I would suggest you voting this idea at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16891147-dynamic-conditional-formatting

Best Regards,

Teige