Conditional Formatting on Column Series in Chart

[RobbieRalph]

Hello Power BI Community,

I am struggling with this and dont know if there is a current solution. So I invested alot of time assigning Hex colours to different flavours/variants of products. I can now easily link this into a simple column chart when I select product as the main category axis. The issue that I have is that when I need to add another category (time in this example), the product then becomes the "Column Series" and when you go to column options, there is no place to choose conditional formatting.

Really hoping there is a way to do what I am trying to achieve

My table:

What the chart needs to look like (currently incorrect colour assignment)

Correct colours working in a simple chart with no time axis

 

[RobbieRalph]

How do I upload the PBIX - doesnt allow me to do it here? is this option only available on new posts?

[lbendlin]

Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. 

[RobbieRalph]

https://drive.google.com/file/d/1u4DQCqy3WYbrYzd_uWl1Y8VTQGtlyHSQ/view?usp=sharing

No worries - Uploaded sample PBIX to Google Drive. Thanks for your help so far!

[v-luwang-msft]

HI @RobbieRalph ,

Could you pls share your sample data and expected output  visual? 

Best Regards

Lucien