Forum Discussion
Power ParticipantConditional 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
Community ChampionHamidBee 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
HamidBeeYes, that did the trick. Thanks