Forum Discussion
Conditional Formatting on Column Series in Chart
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
4 Replies
HI RobbieRalph ,
Could you pls share your sample data and expected output visual?
Best Regards
Lucien
How do I upload the PBIX - doesnt allow me to do it here? is this option only available on new posts?
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.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!
