Conditional Formatting Data Colours for more than one field in a bar chart not working

HamidBee since you have seperate column for each field, you wont be able to have conditional formating. In this case, i suggest you to unpivot your data in the power query window so that you have one column for cat and second column for value. once you do this, then you will get option to have conditional formatting

this is how you can unpivot your data

then you can have conditional formatting option enabled.

and this is how you set the conditional formatting